Forum Discussion

tuncay's avatar
tuncay
Icon for Helper III rankHelper 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...
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 ^__^. 

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
3 years ago

is getdiv supposed to be a number or a value?

tuncay's avatar
tuncay
Icon for Helper III rankHelper III
3 years ago

a value, it should filter the division (e. g. "A" or "B")

 

I tried also the following, does not work:

var BiC = CALCULATE(MAX('KPI data'[Value]), FILTER(ALLSELECTED('Organizational Unit'), [Division]))
  • tuncay's avatar
    tuncay
    Icon for Helper III rankHelper III
    3 years ago

    or this

    var BiC = CALCULATE(MAX('KPI data'[Value]), ALLEXCEPT('Organizational Unit','Organizational Unit'[Division]))

     

     

     

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    3 years ago

    it should filter based on one value or multiple?

     

    VAR div =
        SELECTEDVALUE ( 'Organizational Unit'[Division] )
    VAR BiC =
        CALCULATE (
            MAX ( 'KPI data'[Value] ),
            FILTER ( 'Organizational Unit', 'Organizational Unit'[Division] = div )

    • tuncay's avatar
      tuncay
      Icon for Helper III rankHelper III
      3 years ago

      it still does not show any value...