trinhlt
trinhlt

Reputation: 11

Power BI: How to calculate multiple similar measures based on other measures and display them in rows

enter image description here

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:

  1. Is there a faster way to calculate this, instead of creating 7 new measures?
  2. How to display the %profit row in the created table?

Upvotes: 0

Views: 26

Answers (0)

Related Questions