Forum Discussion
Solved
Count Value with condition
Hello, how can i replicate the result of the table below. I need to count the number of store for each rating with a filter on only the stores that have first and second ride.
Hi,
I got this with the attached pbix
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi Morrison ,
1. Create new column as
Column = IF( 'SAMPLE'[SCORE]="ENOUGH","ENOUGH","INSUFFICIENT")
2.Create new column as
LAP1 = IF('SAMPLE'[LAPS]=1 ,COUNT('SAMPLE'[STORES]))
LAP2 = IF('SAMPLE'[LAPS]=2 ,COUNT('SAMPLE'[STORES]))
Best Regards,
Shreya Mukkawar
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thx all for the support 🙂