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.
@AlexisOlson @parry2k How can I selectively display subtotal for a measure (with or without CalGrp) ; Currently I am doing this
PFA Sample
Thank you in advance
Solved! Go to Solution.
I'm not sure I fully understand what you want the output to be (a bunch of blank total lines?) but I would try ISINSCOPE instead of HASONEVALUE.
Hi @smpa01 ,
Thanks for the reply from @AlexisOlson / @lbendlin .
Have you tried using the function provided by AlexisOlson ?
Did it help you solve the problem?
If yes, please accept his answer as the solution, which will be of great help to users who encounter similar problems as yours.
If you have any further questions, please feel free to contact me.
Best Regards,
Yang
Community Support Team
I'm not sure I fully understand what you want the output to be (a bunch of blank total lines?) but I would try ISINSCOPE instead of HASONEVALUE.
This is a blind spot - if a parent category only has one child the HASONEVALUE is ineffective.
Have you considered selectively disabling the row total for that category?
Thanks @lbendlin I don't think it would work the I way I want it. I was hoping for a progrmatic way to achieve this if possible
//pseudocode
if(max(tbl[cat])=3 && issubtotal(tbl[_input])=true(), [_input],BLANK())
Yeah, ISSUBTOTAL function (DAX) - DAX | Microsoft Learn has its own limitation. You can't use it to sense where in the visual you are.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |