topic DAX Guidance - Intersection of Categories from two slicers (selection) on a Matrix Visual in DAX Commands and Tips

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

VikasNegi — Sat, 01 Jul 2023 21:36:55 GMT

Hi Community,

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

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

VikasNegi — Sun, 02 Jul 2023 15:40:13 GMT

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

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

v-zhangti — Mon, 03 Jul 2023 06:44:13 GMT

Hi, VikasNegi

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

Best Regards

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

VikasNegi — Mon, 03 Jul 2023 11:33:57 GMT

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!

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

v-zhangti — Tue, 11 Jul 2023 08:34:04 GMT

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.