Matrix Not Showing Column Grand Totals

[ilostmyadd]

HI,

I created a measure to show the Sales and GP, the source of the Sales and GP uses different formulas which works well. The issue is matrix Grand Total don't show any value. 

Below is the measure used.

mes_SimplifiedSales =

    SWITCH(

            SELECTEDVALUE(Fact_Actuals_Materialised[Level1]),

            "Equipment Sales",[mes_BrEquipRevenue],

            "Long Term Rental",[mes_RentalRevenue],

            "Short Term Rental",[mes_RentalRevenue],

            "Driver Training", sum(Fact_Actuals_Materialised[Sales]),

            "Parts", sum(Fact_Actuals_Materialised[Sales]),

            "Service", sum(Fact_Actuals_Materialised[Sales])

        )

Output: No values on Totals (Yellow background)

Any ideas?

Thanks.

[some_bih]

Hi @ilostmyadd , check if this help 

https://community.powerbi.com/t5/Desktop/Grand-Totals-not-displaying-with-Matrix-with-screenshot/m-p...