Building a Multi KPI Table

[Imrans123]

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?

[johncolley · Accepted solution]

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!

[Imrans123]

Perfect! Thank you!