Forum Discussion
Nick_2510
Helper I
4 years agoTotal 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
1 Reply
- amitchandak
Super User
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