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 , Create three columns like

 


countif= countx(filter(Table, [name] =earlier([name]) && [company] =earlier([company] && [Date] <=earlier([Date])), [name])

 

HC = if([countif] <=1,1,0)

 

HC1 = divide([HC],Sumx(filter(Table, [name] =earlier([name])), [HC]))

  • saumitra's avatar
    saumitra
    Helper I
    5 years ago

    Hi Amit, 

    Tried what you said but getting this error. Correct me if possible. 

     

    Thanks!