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

a10703 · ‎03-28-2022

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:

Thanks for all help 🙂

coskuersanli · ‎03-28-2022

Hi @a10703 ,

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

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

coskuersanli · ‎03-28-2022

Hi @a10703 ,

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

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

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