Forum Discussion
Ignore Visual level filter in measure
Hi wonderful PBI community, I am unsure if this is possible but thought I would ask. I have a measure that calculates a total bonus earnt and I use a visual level filter to taylor this to the...
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
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.