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 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