Forum Discussion

saumitra's avatar
saumitra
Helper I
5 years ago

CountIFS With Multiple Criterion

Hi All, I want to use the CountIfs formula of Excel in Power BI for 3 criterias, which are Name, Company Name and Date. However, I am unable to do so in Power BI.  I am using the following formula ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
5 years ago

saumitra , what is the filter for company and date ?

example meausre 

Count = Calculate(CountA(Table[Name]),Filter(Table , Table[Company Name] = "ABC" && Table[Date] = date(2020,1,1)))

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • saumitra's avatar
    saumitra
    Helper I
    5 years ago

    Hi Amit,

    This is a sample of Excel data. These are the formulae I want to use in Power BI.  

    I hope this helps.

     

    Thanks,

    Regards,

    Saumitra Upadhyaya