Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Countifs in powerbi?

Here is my formula I use in excel to count the number of unique vendors with criteria language pair and subject matter.   =COUNTIFS(DataDump1!$C$2:$C$139526,A2,DataDump1!$E$2:$E$139526,B2)   Here...
  • Anonymous's avatar
    Anonymous
    8 years ago

    This is what I was looking for:

     

    =
    CALCULATE (
    COUNTROWS ( DataDump1 ),
    FILTER (
    DataDump1,
    DataDump1[languagePair] = EARLIER ( DataDump1[LanguagePair] )
    ),
    FILTER (
    DataDump1,
    DataDump1[Subject Matter] = EARLIER ( DataDump1[Subject Matter] )
    )
    )

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Did Zubair_Muhammad's solution work? You need to use it in a visual?

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago

No, it didn't work for me. I was able to find a different solution. Thanks for looking into this for me! I really appreciate.