Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

DistinctCount IF?

Hi All,   I'm new to Power BI (and DAX) coming from Tableau.   I've got a question regarding the DiscountCount function.   I need to calculate a percentage of orders that include a certain item...
Need Help
  • greggyb's avatar
    greggyb
    10 years ago
    CALCULATE(
    DISTINCTCOUNT( FactOrder[OrderNumber] )
    ,FactOrder[Line Item] = <certein item number>
)
greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago
CALCULATE(
    DISTINCTCOUNT( FactOrder[OrderNumber] )
    ,FactOrder[Line Item] = <certein item number>
)
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Worked perfectly! Thank you so much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    If you want to understand the reason behind that answer, check this out: http://www.powerpivotpro.com/2009/12/powerpivot-dax-calculate-is-a-supercharged-sumif/

     

    Actually the title of that blog post is slightly misleading; CALCULATE is a supercharged WHATEVERIF. COUNTIF, SUMIF, DIVIDEIF, etc. depending on what kind of expression you feed into it. That whole blog is a fantastic resource for learning DAX, and they've got a great book as well.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Thank for the resource, I really appreciate it!