Forum Discussion
Exclusion
Looks like this did not poast the first time, so trying again.
I am writing Medical reports and need to be able to compare results by exclusion.
Example: I have classes of conditions that contain individual health conditions. The easy part is to just filter on a class to get the Med total paid. I need to compare this with the opposite, i.e. Med total paid for everyone not in that class that is filtered.
I SQL I would do this by getting all people and remove the people that have the conditions within the class, then sum the Med total paid for these people. How do I do this within DAX?
Similarly: I want to see a med total for peopl who have any condition and contrast that with med total for people who do not have any condition.
3 Replies
- AnonymousNot applicable
Since you're new to these forums... Please first get familar with this: https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523
Thanks.
- spartan27244Resolver I
Already read through it
- AnonymousNot applicable
OK. I'll give you a piece of free advice 🙂 If you don't get answers from anyone within a reasonable period of time, it means your description of the problem is not clear enough.
DAX can't be written in vacuum.