Count Value with condition

[Morrison]

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. 

[Anonymous]

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.

[Morrison]

Thx all for the support 🙂

[serpiva64 · Accepted solution]

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 !