Forum Discussion
Nick_2510
Helper I
Helper ITotal ignore measures
Hi everyone! Please help How can I get in total (pivot table) - sum of values ignoring measures. Exactly, not apply measures to total. In total I should get 165 098
You measure should be like
Add your visual column in summarize
Sumx(Summarize(Table, Table[Market], table[Other Column],table[Other Column3]), [Measure])
or refer
amitchandak
Super User
Super UserYou measure should be like
Add your visual column in summarize
Sumx(Summarize(Table, Table[Market], table[Other Column],table[Other Column3]), [Measure])
or refer