Forum Discussion
Filtered Column Before applying DAX
Hi All, I have a table consisting Customer code, product code and multiple calculated measures and columns. I have calculated "AND/Intersection" logic to calculate how many customer bought items in ...
HI,
Anonymous
Basically i have created columns based on filter in SQL only and then just implement interesection Dax without any filter and now its working.
But what if i want to get the list of customers who bought common items.
In other words, can i have a list of customers based on your DAX??
Hi Anonymous ,
My formula is merge your filter condition with summarize table and get corresponding user count.
>>But what if i want to get the list of customers who bought common items.
You can write measure to get filtered records and apply on visual level filter to compare and filter records. Can you please share some detail information to help us clarify your requirement? (e.g. expected result, table data structure)
Regards,
Xiaoxin Sheng