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

Countif with multiple criteria

Hi,

 

I am working on People's data and I want to derive a number basis multiple criteria being fetched from base data, below is the formula I have inbuilt in excel and want replication of same on Power BI

=COUNTIFS('Base Data'!$M:$M,"V",'Base Data'!$C:$C,Sheet1!$G$7,'Base Data'!$Z:$Z,"new",'Base Data'!$I:$I,Sheet1!$B14,'Base Data'!$O:$O,Sheet1!$E$7,'Base Data'!$O:$O,Sheet1!$E$8,'Base Data'!$J:$J,Sheet1!$C$11)

 

Can anyone help here??

 

Thanks In Advance

 

Snapshot.PNGBase Data Headers.PNG

1 REPLY 1
rafaelmpsantos Established Member
Established Member

Re: Countif with multiple criteria

Calculate(count(Table[Column]);Filter(Table;FiltersCriteria))

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 39 members 962 guests
Please welcome our newest community members: