DAX Guidance - Intersection of Categories from two slicers (selection) on a Matrix Visual

[VikasNegi]

Hi Community,

I'm quite new to PBI and looking to get the solution to a business problem. Any help would be greatly appreciated -

[v-zhangti]

Hi, @VikasNegi 

Please advise the relationship between C1C2 and P1P1 in the main table?

Best Regards

[VikasNegi]

Hi @v-zhangti  -Thanks for looking into this. Below are the details. Please let me know if you need any further information -

One Product (P1 / P2) can be present across multiple categories (C1 /C2/ C3, etc) and both are present in the same table. So suppose, If I select C1 from the first slicer and C2 from the second slicer (Both Slicers on one column Categories of this table), I want to see the Products common in both categories only else a blank Matrix visual.

Thanks in advance!

[v-zhangti · Accepted solution]

Hi, @VikasNegi 

If the relationship between P1P1 and C1C2C3 looks like this:

Is this the result you want? If not, please explain why the content of P2 was not selected.

Best Regards,

Community Support Team _Charlotte

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

[VikasNegi]

Hi Guys, Any Idea about my queries? Please let me know if any more information is needed for more understanding.