topic Re: How to find % of total with multiple filters in place. in DAX Commands and Tips

How to find % of total with multiple filters in place.

gcrisp — Mon, 23 Jan 2023 14:55:11 GMT

I have a file that contains the following information:

Drug Type (Generic, Brand, Specialty)

Rx Count (n=1)

Disease State Grouper (many different categories)

I am trying to find out what % of Rx Count is Generic but with Disease State Grouper (Vaccinations) excluded.

The issue I am running into is that for the denominator, I want it to be all Disease States within grouper Except Vaccines and the numerator to only include Drug type of Generic. I cannot seem to find a way to do both and keep the % filtered.

Thanks for your help.

Re: How to find % of total with multiple filters in place.

FreemanZ — Mon, 23 Jan 2023 16:00:57 GMT

hi gcrisp

are you expecting something like:

Pct = VAR _b = COUNTROWS( FILTER( TableName, TableName[Disease State Grouper] <>"Vaccines" ) VAR _a = COUNTROWS( FILTER( TableName, TableName[Disease State Grouper] <>"Vaccines" &&TableName[Drug Type]="Generic" ) RETURN DIVIDE(_a, _b)

Re: How to find % of total with multiple filters in place.

gcrisp — Mon, 23 Jan 2023 16:03:40 GMT

Trying that now. That looks similar to what I was doing.

Re: How to find % of total with multiple filters in place.

gcrisp — Mon, 23 Jan 2023 16:19:58 GMT

I am a beginner with this so I am wondering if it is not working because I am putting the wrong thing for "pct", Var_a and Var_b. Should those be something more specific than as typed?