Count the data from filter rules

[RickyTWK]

Hello, I work from construction company.

I would like to count two type of data which are naming start with "RFI-A" and "RFI-BS"

Can I do this in single column? 

Thank you so much!

[Arul · Accepted solution]

@RickyTWK ,

Try this two measures,

RFI-A = CALCULATE(
    COUNT('Table (2)'[RFI NO]),CONTAINSSTRING('Table (2)'[RFI NO],"RFI-A"))

RFI-BS = CALCULATE(
    COUNT('Table (2)'[RFI NO]),CONTAINSSTRING('Table (2)'[RFI NO],"RFI-BS"))

Thanks,

Arul

[RickyTWK]

The formula not work....

Am I missing somethings?

Measure 2 = CALCULATE(COUNT('Issues'[RFI No.],CONTAINSSTRING('Issues'[RFI No.],"RFI-A")))

I provide more information, the column of "RFI. No" have a lot of empty data.
Only 11 row has value which are RFI-A and RFI-BS

Thanks!

[Arul]

@RickyTWK ,

You are missing close bracket for count and remove one close bracket at the end.
Put a ) at yellow marked place before the comma and remove bracket at red marked place at the end of the formula..

Thanks,

Arul

[pratyashasamal]

Hi @RickyTWK ,
You can use COUNTX function and create a measure .
https://learn.microsoft.com/en-us/dax/countx-function-dax
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