Forum Discussion

amotto11's avatar
amotto11
Helper II
8 years ago
Solved

Countifs Function

Hello, I am pretty new to PowerBI, and I am trying to write a DAX expression for a column that would use Excel's version of countifs. Below is my data, the final column would be the output. The formu...
Need Help
  • amotto11's avatar
    amotto11
    8 years ago

    I was able to get it. The table i created was from the following formula, then i just linked it to my existing table and created a slicer on the QuoteID and selected all except blank. Thank you for your help!

     

    =DISTINCT(FILTER(table,table[CompanyID]=1))

alena2k's avatar
alena2k
Resolver IV
8 years ago

Try to use calculated column instead of measure, it will allow you to use all possible filters in visuals:

 

x =
CALCULATE(
COUNTX('tbl', DISTINCTCOUNT(tbl[QuoteID])), 'tbl'[CompanyID] =1
)