Exclusion

[spartan27244]

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.

[Anonymous]

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.

[spartan27244]

Already read through it

[Anonymous]

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.