cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
a10703
Frequent Visitor

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

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: 

GROUPTYPE
ASR
BSR
BINC
ASR
CINC
BINC
BSR
ASR

 

Thanks for all help 🙂

1 ACCEPTED SOLUTION
coskuersanli
Super User
Super User

Hi @a10703 ,

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

 

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

View solution in original post

1 REPLY 1
coskuersanli
Super User
Super User

Hi @a10703 ,

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

 

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.