Forum Discussion

Stewwe's avatar
Stewwe
Icon for Helper II rankHelper II
4 years ago
Solved

Visual level filter with a conditional "or condition"

Hello dear PowerBI Community, I have the following request from a user and would appreciate your help. The user would like to be able to filter a visual in the following table:   Item Item Va...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi Stewwe ,

     

    First create 2 dim tables as below:

    dim1 = GENERATESERIES(1,MAX('Table'[Item Quantity]),1)
    dim2 = GENERATESERIES(1,MAX('Table'[Item Value]),1)

    Then create a measure as below:

    Measure = IF(SUM('Table'[Item Quantity])>SELECTEDVALUE(dim1[quantity])||SUM('Table'[Item Value])>SELECTEDVALUE(dim2[Value]),1,BLANK())

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Stewwe , Try a measure or all measures should follow

 

calculate(sum(Table[quantity]), filter(Table,Table[quantity] >500  || Table[Itemvalue] >50))

  • Stewwe's avatar
    Stewwe
    Icon for Helper II rankHelper II
    4 years ago

    Thank you amitchandak for your solution.

    However, the user should be able to set the filter values dynamically and not store fixed values in the formula.

     

    That is the challenge 😉

     

    Bye


    Stewwe