topic Re: DAX to get a % based on non blanks in DAX Commands and Tips

DAX to get a % based on non blanks

EmilyM2019 — Wed, 07 Apr 2021 17:24:26 GMT

Hi all,

I currently have the below measure to calulate the % of Yes's within a column, the DAX for this I am uing is:

DIVIDE(CALCULATE(COUNTROWS('Psych data'),'Psych data'[Appointment required] = "Yes"), CALCULATE(COUNTROWS('Psych data')))

The problem is my column 'Appoinment required' contains Yes, No and Blanks. How do I get it to exclude the blanks so the % is being calculated just on the rows with Yes and No?

Any help would be appreciated.

Regards,

Emily.

Re: DAX to get a % based on non blanks

Jihwan_Kim — Wed, 07 Apr 2021 18:21:04 GMT

Hi, EmilyM2019

In my case, I use countblank ( column name) function and subtract from it.

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

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Re: DAX to get a % based on non blanks

Anonymous — Wed, 07 Apr 2021 22:35:25 GMT

[Measure] = CALCULATE( DIVIDE( CALCULATE( COUNTROWS( 'Psych data' ), KEEPFILTERS( 'Psych data'[Appointment required] = "Yes" ) ), COUNTROWS( 'Psych data' ) ), KEEPFILTERS( NOT ISBLANK( 'Psych data'[Appointment required] ) ) )