Matrix Total Measure

[Suhel_Ansari]

Hi All,

I need DAX Expert to create the measure called "DELI VS REN" which should be

"IF(Terminations > Deliveries than Terminations else Deliveries) and the subtotal for "Salesman 1" should be Sum of "DELI VS REN" as seen in the following screen shot, please assit. I need the measure becuase i can not create a column because it is connected to SSAS as Datasource. Thanks

Regards

Suhel

[amitchandak · Accepted solution]

@Suhel_Ansari , Try a measure like

Sumx(summarize(Table, Table[Salesman Name], Table[Agent Name], "_1", IF([Terminations] > [Deliveries], [Terminations] , [Deliveries])), [_1])