Apply AND Logic to Multiple Selection in DAX Slicer

[kateanderson]

Thank you! I've just used this on my first foray into DAX, solving a real-world problem. You the explained it so clearly that it only took me an hour to figure out how to use this approach for our slightly different use case.

[Darknesslc]

very intimating dax for a beginner, much more to learn

[Bharath_PBI]

Thank you again for another video. This logic gives more options for DAX coders to alter the default behaviour of power bi 👍

[joserafaelfarfanfernandez]

Hi Alberto, great tutorial, really useful as usual. Based on your example what options do I have if I need to show who are those clients ? Thank you so much.

[triparnaray]

We are checking the number of categories is equal to the number of categories purchased by a given customer (2 categories in this example) but where we are making sure that its count of customers who purchased specifically these 2 categories? Please can you share your idea.

[Miekjaah]

Hi Alberto, what a great video! I got this to work in my own dashboard. My next step is to calculate the number of customers that ONLY bought products of ALL the selected categories. How should I approach this? Thanks in advance for your help!

[BernatAgulloRosello]

I'll put this video in a list named "the art of dax" I think. Awesome.

[definlykrithi]

Thank you for making these videos! Saved my day

[Brezisnki]

I have two tables and have a slicer selecting multipule components to return all the master items containing only these selected components. However, I am still getting a return of all items with selected from slicer.

[michaelribbins]

Hi, Great Video it has really helped with a project I am working on. Is it possible to display the CustomerKey for each customer that purchased the selected items? I would love to have a second table that lists all customers that bought at least a TV and Video as well as Computers.

[Paul-tmlw]

DAX god at it again. Great video! Thanks for posting

[DanielADamico]

Excellent as always! You guys are awesome!

[hemanadezhdank]

Is it possible to assign the selected value dynamically to pull in different column values. Say, YTD, MTD, QTD as the selected value in the slicer and they are the separate columns in time dimension. Then how is it possible to pick the YTD, MTD, QTD flags from time dimension table. Please suggest.

[yacobberk]

HI,
Thanks for the excellent exercises.
One step can be omitted:

Customers with all categories =
VAR NumOfSelectedCategories =
COUNTROWS ( VALUES ( 'Product'[Category] ) )
VAR CustomersAndCategories =
SUMMARIZE (
Sales,
Customer[CustomerKey],
)

VAR CustomersWithAllCategories =
FILTER (
CustomersAndCategories,
)
Var Result = COUNTROWS (CustomersWithAllCategories)
Return Result

But this solution takes longer to execute.

[Mateusz_]

This is really great and helped me a lot!

[mariavillanueva]

Hi Alberto! A great tutorial!! But I have a problem with the last step, when you change the sales[customerkey] for customer[customerkey], I get an error message from the line of the summarize that says that customer[customerkey] isn't found in the input table. But I have the field in both of them... Could you help me? Thanks in advance!

[nupursrivastava]

How to show the name of all customers who bought from category 1 & category 2 both?

[AlbertoGastaldo]

Hi Alberto
In the formula you compare the number of selected categories in the slice with the number of categories that each customer bought
However if I select “computers” and “TV and video “ I expect the measure to show how many customers bought THOSE categories
It looks like your measure returns customers the bought TWO categories not the selected ones
Am I missing something ?
Thanks

[김차수-ku]

hello this is chasoo kim. thank you for your excellent video.

but one thing i coundn't understand is that about data lineage.
you mentioned that the reason why you use groupby is for data lineage. could you explain this?

best regards

[raulvera]

Thanks for the video. excellent as always... could be great if you go in another video to describe how to build THIS Calculation Item! :-)