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!

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
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!

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

    Thank you! Exactly what I was looking for. 🙂