topic Re: Whats the dax formula to support my scenario? in DAX Commands and Tips

Whats the dax formula to support my scenario?

mkathi0405 — Wed, 22 Jul 2020 23:34:06 GMT

Let's say if I select option A and B from a smart filter. Imagine the selected options as a venn diagram. Intersection of A and B are common values but im not interested in this.

I need to find out the independent B (excluding the intersected part) if I select A. Basically I would like to find out the gaps. The formula should be dynamic enough if I choose options A B C etc. Thanks 😊

Re: Whats the dax formula to support my scenario?

Greg_Deckler — Wed, 22 Jul 2020 23:48:51 GMT

mkathi0405 - Not quite sure I understand. Seems like something like the Inverse Selector or Complex Selector:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

If not, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Whats the dax formula to support my scenario?

amitchandak — Thu, 23 Jul 2020 02:56:30 GMT

mkathi0405 , see if these function can help

https://docs.microsoft.com/en-us/dax/intersect-function-dax

https://docs.microsoft.com/en-us/dax/except-function-dax

https://docs.microsoft.com/en-us/dax/union-function-dax

Re: Whats the dax formula to support my scenario?

Anonymous — Fri, 24 Jul 2020 06:49:51 GMT

Hi mkathi0405 ,

You cna try this.

Create measures using EXCEPT and use the method from the video to use as a Slicer.

https://www.youtube.com/watch?v=_sxLEGRCo28

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!