COUNTROW based on words

[gazzo1967]

HI All

I know this is newbie question (which i am)

I would like to have a total count based on word/s in a row, this is so i can compare my sharepoint list data against a total count of a specific jobtitle.

I have tried

WatchCount = CALCULATE(COUNTROWS('User Information List'),'User Information List'[JobTitle]="Watch Commander")

And

WatchCount = CALCULATE(DISTINCTCOUNT('User Information List'[Id]),'User Information List'[JobTitle] = "Watch Commander")

But i can not see a figure for the count!

Am i doing this right?

As i said i am new to this and been a steep learning curve for Powerapps and Flow now the boss wants the outputs!!

Regards Gary

[Mariusz · Accepted solution]

Hi @gazzo1967 

Providing that you have only two abriviations of Watch Commander ( A, B ), you could use the DAX expression below.

WatchCount = 
CALCULATE( 
    COUNTROWS( 'User Information List' ),
    'User Information List'[JobTitle] IN { "Watch Commander A", "Watch Commander B" }
)

This will give you the below result.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.