Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a problem with the visualization of a measure in a matrix visual.
the measure i have calculates efficiency by doing this
efficiency= costs/revenues of the previus year * revenues of this year - costs of this year
it works good but i have the problem that you can see here
I can assure yuo that the values (-2 and -233 or +276 and -285) are right.
Power BI calculates the measure even at the higher level (-306 and -94) but obviously it's not the sum of the single values.
How can I manage to have the measure shoe the value I want (-235 and -9) when showing at the higher level of the hierarchy?
Please see this video for getting the right subtotals.
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you!
I watched the video and i'm trying to work wit those suggestions. But it doesn't work form me, could it be because i put in the visual row fields coming from different tables?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |