Forum Discussion
Ignore Visual level filter in measure
Hi Anonymous,
It is possible.
You need to modify [Total Bonus] measure. I would suggest to use ALL() in your CALCULATE() to remove context of filter you are applying in visual level filter.
Check this link for syntax of ALL().
Prateek Raina
Hi, Thanks. I guess I need to be more clear around these measures. Team Bonus is made up of [Team Conversion]+[Team GP] and those measure are look up values on a table for e.g
Team Conversion =
CALCULATE(
LOOKUPVALUE('Bonus Payments'[Team Conversion $$],'Bonus Payments'[Team Conversion],
ROUNDDOWN('Sales Measures'[Conversion],2)))+0
This is so I can edit the spreadsheets easily when the targets change. SO I am struggling to an ALL into this.
Hi Anonymous,
Can you screemshot your relationship between tables and also tell which column are you using in the visual level filter.
After this input only, we will be able to tell that where you should change to accomplish the result.
Prateek Raina
Hi
I have 17 Seperate data tables and 4 seperate tabes of measures. However the only relationship in effect here is the User table and the Sales Data table.
I donlt think what I am trying to do is possible so I will need to figure out a different way to calculate the bonus figures.Hi
I have 17 Seperate data tables and 4 seperate tabes of measures. However the only relationship in effect here is the User table and the Sales Data table.
I donlt think what I am trying to do is possible so I will need to figure out a different way to calculate the bonus figures.