Countrows Measure

[Greendom898]

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

[Ahmedx · Accepted solution]

try like this

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

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

[pratyashasamal]

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