DAX to get a % based on non blanks

[EmilyM2019]

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.

[Anonymous · Accepted solution]

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

[Jihwan_Kim]

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.