Forum Discussion

RickyTWK's avatar
RickyTWK
New Member
3 years ago
Solved

Count the data from filter rules

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!  
Tips and Tricks
Tutorial Requests
  • Arul's avatar
    Arul
    3 years ago

    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

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

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