Forum Discussion
Building a Multi KPI Table
Hey All,
Wanted some help from you guys. My data model is such that I have a billings table with sales data and a column called store ID which represents the store the sale is happening at. Just a rough example below,
And a Dimensions table
I have a relationship between store ID off the two tables.
Now, I have made 6 DAX measure, Sales (Sum of amount), Cost (sum of Cost), Profit (Sum of amount-cost), Sales Target, Cost Target and Profit Target
I want the final product to look something like this
Now, I already got all the measures built. I can do a matrix visual where I put store name in rows and DAX measures Sales, Cost and Profit in values to get a table that lists all stores and their respective Sales, Cost and Profit. However, I can't get the target measure in there to align with their respective KPI.
Is there a way I could do this in the default Matrix visual using DAX? Or is there a custom visual that satisfies my requirement where I can allocate a target measure for each KPI measure?
Hi Imrans123 ,
You can try combining the results and target into one measure to use in the matrix. For example:
Combine = COMBINEVALUES(" / ", Sales Measure, Sales Target Measure)If this answer solves your problem please mark it as a solution!
2 Replies
- johncolleySolution Sage
Hi Imrans123 ,
You can try combining the results and target into one measure to use in the matrix. For example:
Combine = COMBINEVALUES(" / ", Sales Measure, Sales Target Measure)If this answer solves your problem please mark it as a solution!
- Imrans123Advocate V
Perfect! Thank you!