Forum Discussion
tuncay
Helper III
Helper IIIOnly 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 ^__^.
tuncayHelper III
Helper IIIdoes someone have an idea?
hnguy71
Super User
Super Usertuncay hard to tell what the issue is without seeing your model, but ALL or ALLSELECTED should work. How about this?
VAR div = SELECTEDVALUE('Organizational Unit'[Division])
VAR BiC = CALCULATE(MAX('KPI data'[Value]), ALL('Organizational Unit'), KEEPFILTERS('Organizational Unit'[Division] = div))
- tuncay
still not working...
- tuncay
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...
- hnguy71
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 ^__^.