Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I'm trying to think of the best way to bring in KPI values from a table as I have two duplicate reports (UK and US) and each has different value's for the KPIs with each report pointing to a diffeent database of data.
Initial thoughts are to create a table with one row with the field names as the KPI name and the value is the value of the KPI but I really don't think that is great.
Does anyone else have a nice way of doing this? My KPIs at the moment are defined as metrics but they need to be data driven!
Thanks
Mattie
Solved! Go to Solution.
Hi
Basically I want to be able to load this structure and replace my current KPI Measure values definied in Power with these pairs of values from a database:
KPIID (int)
KPIName (varchar) - just for reference as name will be a measure in Power BI
KPIValue (float)
I'm going to load this table into Power BI and then do a lookup on the KPIID and set the value of the new measure to the value from the database.
I think I have answered my own question tbh but I'm surprised there isn't much information on this.
DAX LOOKUPVALUE seems like it will work well 🙂
Thanks
Mattie
@MattieG72MP could you send us a screenshot of the data relationship model? Where is the data coming from?
Hi
Basically I want to be able to load this structure and replace my current KPI Measure values definied in Power with these pairs of values from a database:
KPIID (int)
KPIName (varchar) - just for reference as name will be a measure in Power BI
KPIValue (float)
I'm going to load this table into Power BI and then do a lookup on the KPIID and set the value of the new measure to the value from the database.
I think I have answered my own question tbh but I'm surprised there isn't much information on this.
DAX LOOKUPVALUE seems like it will work well 🙂
Thanks
Mattie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |