Matrix - hide selected rows but compute them in the total

[MagikJukas]

Hi,

I have a matrix with a family hierchies structure in the rows.

Some families are very small and not I would like to hide them from the visualization.

If I hide them, the total not matching anymore, since the hidden figures are not computed.

Is there a setting I can turn on/off or do I have build a measure to achieve this?

regards

[amitchandak · Accepted solution]

@MagikJukas , Change you grand total using isfiltered or isinscope

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[MagikJukas]

ok, thanks, probably this is the only way to do it.

thanks