Forum Discussion
Solved
Only consider one filter
I want to show in a chart, the best value of a Factory within a Division. I tried that, but I get 0 value in the chart. With the same function, when I put it into a Card, then I can see the best...
tuncay seems like there's another filter applied somewhere. Can you try to add an ALL to your main table and see if any info comes out?
VAR div = SELECTEDVALUE('Organizational Unit'[Division]) VAR BiC = CALCULATE(MAX('KPI data'[Value]), ALL('KPI data'), ALL('Organizational Unit'), KEEPFILTERS('Organizational Unit'[Division] = div))I'm grabbing at thin air since I can't really explore and see what your model looks like ^__^.
still not working...
it's not showing in the chart as a column, but when I put the exact same code to a card, I can see the correct value...
tuncay seems like there's another filter applied somewhere. Can you try to add an ALL to your main table and see if any info comes out?
VAR div = SELECTEDVALUE('Organizational Unit'[Division]) VAR BiC = CALCULATE(MAX('KPI data'[Value]), ALL('KPI data'), ALL('Organizational Unit'), KEEPFILTERS('Organizational Unit'[Division] = div))I'm grabbing at thin air since I can't really explore and see what your model looks like ^__^.