Matrix column sum disabled on expand

[Anonymous]

Hi,

I need to create report with matrix of data but it is requested explicitly to hide some "sums". Please refer to pictures below, where lets say we have three columns like there. Now I would like first one to have values in rows all the time - both expanded and collapsed. Next only, when rows are collapsed and third one never. Of course all values should appear in simple rows, I want this behaviour only in agregation ones. Is it possible? Can you guide me how to achieve it?

[v-shex-msft]

Hi @Anonymous ,

You can add if statement with conditions to check current row contents, then you can ignore calculation on specific category labels.

If you are confused about coding formula, please share some sample data with table format for test.

How to Get Your Question Answered Quickly  
Regards,

Xiaoxin Sheng

[Anonymous]

Thank you for your response. I didn't post any data in this context yet as I was told it was impossible and even though I felt it isn't - just as you say writing the right DAX formulas will do the job - I wasn't so eager to embarass myself.

I'll try to do some job myself and if I fail I'll be back here with what I got and what I need 🙂