I want to display a table like this on my dashboard. Measure 1,...Measure 7 are calculated measures. And the %profit row is calculated based on these measures (e.g. measure 5/measure 7) I can create 7 other measures for the profit row but cannot display them in the same table.
I have 2 questions:
- Is there a faster way to calculate this, instead of creating 7 new measures?
- How to display the %profit row in the created table?