Forum Discussion

Greendom898's avatar
Greendom898
New Member
3 years ago
Solved

Countrows Measure

Hello together,

I have the following table:

Process

AMP - Data

SSI - Service

PPM -  Program

SSI - Service
SSI

SSI - Service

AMP - Data

PPM - Program

 

I would like to have a measure that counts e.g. all rows with the value SSI-Service.

But there are two values in one cell and I can't get it to work, does anyone have a solution? Thanks in advance

Need Help

2 Replies

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi Greendom898 ,
    Please try DAX measure :-

    rownumber = CALCULATE(COUNTROWS(Sheet12),FILTER(Sheet12,MIN(Sheet12[Process])="SSI-Service"))

    Hope this is helpful.
    Thanks ,

    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C 

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago
    try like this

    Sample PBIX file attached
    https://dropmefiles.com/XCBE0

     

    CALCULATE(COUNTROWS(), CONTAINSSTRING('Table'[Process],"SSI")&&CONTAINSSTRING('Table'[Process],"Service"))