Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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.
User | Count |
---|---|
53 | |
35 | |
20 | |
15 | |
14 |
User | Count |
---|---|
94 | |
76 | |
36 | |
22 | |
18 |