Count value in column if the value in other = ??

[a10703]

Hi guys,

I trying to create one measure in my PowerBi Report .

I need to count the number of items if the value in other column are = to SR

So,In column "GROUP" i have 3 type of groups A,B,C IN column "TYPE" i have SR or INC

I need to know how many SR types i have in my group.

I have this measure for count all my total A in column group: CountAGROUP= calculate(counta('Table1'[GROUP]),Filter(Table1,Table1[GROUP]="A"))

How can create this measure?

Table: 

GROUP	TYPE
A	SR
B	SR
B	INC
A	SR
C	INC
B	INC
B	SR
A	SR

Thanks for all help 🙂

[coskuersanli · Accepted solution]

Hi @a10703 ,

You can add one more filter to your measure with &&.

calculate(counta('Table1'[GROUP]),Filter(Table1,Table1[GROUP]="A" && Table1[TYPE] = "SR"))