How to make a DAX measure NOT to re-calculate on aggregated levels?

ArthurOff

New Member
Joined
Aug 20, 2019
Messages
2
I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but I was wondering if there is a way to make it aggregate like a regular number when filtering to top level POV (e.g. instead of looking at July or August, look at Year Total)?
The problem is the aggregated number on the calculated column != the number if it was aggregated in the Planning system in a regular number column
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,089,287
Messages
5,407,381
Members
403,139
Latest member
MrRadioNumbers

This Week's Hot Topics

Top