Matrix Not Showing Column Grand Totals

ilostmyadd — Thu, 18 May 2023 21:48:03 GMT

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.

topic Matrix Not Showing Column Grand Totals in DAX Commands and Tips

Matrix Not Showing Column Grand Totals

Re: Matrix Not Showing Column Grand Totals