KPIs From Database?

[MattieG72MP]

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

[MattieG72MP · Accepted 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

[Anonymous]

@MattieG72MP could you send us a screenshot of the data relationship model? Where is the data coming from?

[MattieG72MP · Accepted 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

[Anonymous · Accepted solution]

@MattieG72MP Awesome!