Forum Discussion
Measure added to a Matrix shown multiple times
- 3 years ago
Hi hdaoued ! Whenever you add a measure to the values box in a visual, Power BI always computes it for every available column (filtering context) and, to my knowledge, there is no way to customize or choose in which columns the measure will be computed. The work around I would do, would be something in the lines of:
1. In your "% of valid certificates" measures add a SWITCH() to show blank values in all rows except the total column (for example in my case I did it like this)
Avg Unit Price = SWITCH( TRUE(), HASONEVALUE('Calendar'[Year]), BLANK(), AVERAGE( Orders[UnitPrice] ) )2. Go to the formatting pane of the visual -> Values -> Options -> Switch values to rows rather than columns
3. The end result will look something like this!
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
goncalogeraldes Thanks! Problem solved as per your suggestion 🙂