Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
shefalityagi
Regular 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
Responsive Resident
Responsive Resident

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.