Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter only common values

Hello,    Trying to filter simple table to get only results that are in common for given customers.   Now If customer A & B are selected, I'd like to see as a result only fruits they have i...
  • ERD's avatar
    ERD
    4 years ago

    Hi Anonymous ,

    You can use these measure:

    commonFruitCheck =
VAR customersPerFruit =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[customer] ),
        ALLSELECTED ( 'Table' ),
        VALUES ( 'Table'[fruit] )
    )
VAR chosenCustomers = COUNTROWS ( ALLSELECTED ( 'Table'[customer] ) )
RETURN
    IF ( customersPerFruit = chosenCustomers, 1, BLANK () )

    Use it to filter your visual (commonFruitCheck is 1). 

    If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

     

ERD's avatar
ERD
Community Champion
4 years ago

Hi Anonymous ,

You can use these measure:

commonFruitCheck =
VAR customersPerFruit =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[customer] ),
        ALLSELECTED ( 'Table' ),
        VALUES ( 'Table'[fruit] )
    )
VAR chosenCustomers = COUNTROWS ( ALLSELECTED ( 'Table'[customer] ) )
RETURN
    IF ( customersPerFruit = chosenCustomers, 1, BLANK () )

Use it to filter your visual (commonFruitCheck is 1). 

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Works like a charm, thank you! 🙂