HI, I'm not able to calculate the intersection in Power BI.
Problem- I have Customer name and Product name in one table as two different columns. If i click on customer name , lets say, mayank and jennifer (multiselect), then number of products should be visible which is common in both. In my example its should be 2 (as product OCEG2 and BRT3 are the product purchased by Mayank and jennifer both.
Plus i want to show the common product name also which is common in both.
This measure is working but it is not giving me what i m looking for.
If i am selecting product 'BRT3' and 'OCEG2' and put Measure2 (what you have created) in values and put Products in column as a matrix Report then it is showing me value of 2 in BRT3 and 2 in OCEG2 and 2 in Total also. The value 2 coming in Total is absolutely correct but BRT3 is bought by 3 customer, similarly OCEG2 is bought by 3 customers and i want to see values as 3 in both product column and 2 in total one.
This DAX is working for me. But what if i want to filter out this DAX based on a Measure? (Lets say, i have a measure of averageproduct sold and want to filter my DAX, given by you,based on that measure where average product sold is greater than 10)
Second thing is i'm still not able to get only customers name which bought both products. I'm getting all customer list: please refer below: