Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
How can I count the Distinct number of cases where the count of "Yes"is > 1
Case no | Yes Column |
12 | |
12 | |
12 | Yes |
13 | |
13 | Yes |
13 | Yes |
Count of Cases = CALCULATE(DISTINCTCOUNT('Table'[Case no]),FILTER('Table','Table'[Yes Col] = "Yes"))
I can calculate the number of cases but i don't want the cases with only one "Yes". So from the above table it should skip case no 12 and should give answer as 1 i.e caseno 13
Thanks!!
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
expected result measure: =
COUNTROWS (
FILTER (
DISTINCT ( 'Table'[Case no] ),
CALCULATE ( COUNTROWS ( FILTER ( 'Table', 'Table'[Yes Column] = "Yes" ) ) ) > 1
)
)
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.
Hello,
Good monrning,
i think above two solutions in one of the solutions useful for you.
Thankyou for replying.
Hi,
Please check the below picture and the attached pbix file.
expected result measure: =
COUNTROWS (
FILTER (
DISTINCT ( 'Table'[Case no] ),
CALCULATE ( COUNTROWS ( FILTER ( 'Table', 'Table'[Yes Column] = "Yes" ) ) ) > 1
)
)
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.
Hi,
Thankyou. This measure works the best.
Regards,
Shubham
@Anonymous , have these two measures
measure 1= calculate(count('Table'[case no]),FILTER('Table','Table'[Yes Col] = "Yes"))
Measure
count GT 1 = countx(values('Table'[case no]), if([measure 1]>1, [case no], blank()))
Thankyou for replying.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |