topic Re: Filter only common values in DAX Commands and Tips

Filter only common values

Anonymous — Mon, 25 Oct 2021 05:47:35 GMT

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 in common (in this case apple & pear), NOT a summary which i presume is using OR function.

Appreciate your feedback

Re: Filter only common values

ERD — Mon, 25 Oct 2021 07:10:09 GMT

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.

Re: Filter only common values

Anonymous — Mon, 25 Oct 2021 07:40:06 GMT

Works like a charm, thank you! 🙂