Forum Discussion

Morrison's avatar
Morrison
Helper I
3 years ago
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. 

 

 

  • serpiva64's avatar
    serpiva64
    3 years ago

    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 !

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    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 !