The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, hope this is an easy fix that I have overlooked.
I have a matrix visual as follows:
The Issue: I am trying to create a total just for the "Count" column (which is actually under Values, so I have to enable "Row Subtotals". However, this gives me totals for all of the values which I dont want.
When I enable Per Row Level, it allows me to select 2 (out of four) measures in the Rows. Selecting either does not help.
I thought the problem was the range measure which might have been messing up the ability to select specific totals, however i tried with a differnt measure in the Rows and did the same thing. Any help would be appreciated.
Solved! Go to Solution.
Hi @Han_Solo ,
Try rewriting the measures like this:
Average =
IF (
NOT ISBLANK ( SELECTEDVALUE ( 'Table'[matrix bottom row] ) ),
<The original [Average] code>
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @Han_Solo ,
Try rewriting the measures like this:
Average =
IF (
NOT ISBLANK ( SELECTEDVALUE ( 'Table'[matrix bottom row] ) ),
<The original [Average] code>
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
@Han_Solo Unfortunately it's not trivial. https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hiera...
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |