Selectively display Subtotal

[smpa01]

@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

[Anonymous]

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

[AlexisOlson · Accepted 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.

[lbendlin]

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]

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]

Yeah, ISSUBTOTAL function (DAX) - DAX | Microsoft Learn  has its own limitation.  You can't use it to sense where in the visual you are.