Hide Total Row in Matrix based on Slicer

[vincenzosava]

Hello, I have a complex Matrix for which I want to remove the Total row based on the selected value in the slicer. This because for some tipe of column (like ratio) the total row doesn't make sense.

This is part of my DAX Measures. The Slicer that contains the column that I select for the calculation is "Indicator Filter". 

Dynamic Indicator Value =
VAR SelectedIndicator = MAX('Indicator Filter'[Indicator])
VAR SelectedResults = MAX('AggregationType'[AggregationType])

VAR AggregatedValue =
    SWITCH(
        SelectedResults,
       "SUM",
            SWITCH(
                SelectedIndicator,
                "Employees", SUM(ResultData[NumberOfEmployees]),
                "Total Assets", SUM(ResultData[TotalAssets]),
                "Total Revenue", SUM(ResultData[OperatingRevenue]),
                "Gross Margin Ratio", SUM(ResultData[GrossMargin]),
                "Cash Ratio", SUM(ResultData[CashRatio]),
               
                BLANK()
            ),
       
    )


RETURN
        AggregatedValue

[Greg_Deckler · Accepted solution]

@vincenzosava Probably the best you can do is to return BLANK for the total in the cases where the total will not make sense. See the following:

First, please vote for this idea: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Matrix-Table-grand-totals-with-Measures/idi-p...

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

You can test for the Total row by using things like ISINSCOPE, HASONEVALUE, etc.