Forum Discussion
Solved
Matrix Total Measure
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...
Suhel_Ansari , Try a measure like
Sumx(summarize(Table, Table[Salesman Name], Table[Agent Name], "_1", IF([Terminations] > [Deliveries], [Terminations] , [Deliveries])), [_1])
Suhel_Ansari , Try a measure like
Sumx(summarize(Table, Table[Salesman Name], Table[Agent Name], "_1", IF([Terminations] > [Deliveries], [Terminations] , [Deliveries])), [_1])