Forum Discussion

tuncay's avatar
tuncay
Helper III
3 years ago
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 value...

 

Need Help
  • hnguy71's avatar
    hnguy71
    3 years ago

    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 ^__^.