Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
[Measure] =
CALCULATE(
DIVIDE(
CALCULATE(
COUNTROWS( 'Psych data' ),
KEEPFILTERS(
'Psych data'[Appointment required] = "Yes"
)
),
COUNTROWS( 'Psych data' )
),
KEEPFILTERS(
NOT ISBLANK( 'Psych data'[Appointment required] )
)
)
[Measure] =
CALCULATE(
DIVIDE(
CALCULATE(
COUNTROWS( 'Psych data' ),
KEEPFILTERS(
'Psych data'[Appointment required] = "Yes"
)
),
COUNTROWS( 'Psych data' )
),
KEEPFILTERS(
NOT ISBLANK( 'Psych data'[Appointment required] )
)
)
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.