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 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
Suhel_Ansari , Try a measure like
Sumx(summarize(Table, Table[Salesman Name], Table[Agent Name], "_1", IF([Terminations] > [Deliveries], [Terminations] , [Deliveries])), [_1])
1 Reply
Suhel_Ansari , Try a measure like
Sumx(summarize(Table, Table[Salesman Name], Table[Agent Name], "_1", IF([Terminations] > [Deliveries], [Terminations] , [Deliveries])), [_1])