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
Resident Rockstar
10 years ago
CALCULATE(
    DISTINCTCOUNT( FactOrder[OrderNumber] )
    ,FactOrder[Line Item] = <certein item number>
)
gp201641's avatar
gp201641
Frequent Visitor
3 years ago

greggyb  Can you please tell me where i am doing wrong, I tried to use your formula