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

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.

Selectively display Subtotal | Microsoft Fabric Community

AlexisOlson
Super User
2 years ago
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.
lbendlin
Super User
2 years ago
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?
- smpa01
  Community Champion
  2 years ago
  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())
  - lbendlin
    Super User
    2 years ago
    Yeah, ISSUBTOTAL function (DAX) - DAX | Microsoft Learn has its own limitation. You can't use it to sense where in the visual you are.
Anonymous
Not applicable
2 years ago
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