Forum Discussion

spartan27244's avatar
spartan27244
Resolver I
5 years ago

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