Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with Conditional Formula in Dax

Hello all, I am new to PowerBI so I need your help. I am trying to count the order id if a certain price but it shows as errors. I am trying to calculate the orderid if they have the price of 5...
Need Help
  • timg's avatar
    timg
    5 years ago

    Hi Rhoang,

     

    could you formulate your measure as referenced below? This should work

    CountTest =
CALCULATE (
    COUNT ( 'TestTable'[ID] ),
    TestTable[Value] = 5.92
        || TestTable[Value] = 4.87
)

     

    Best regards,

     

    Tim

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It worked woohoo. Thank you so much Tim!

Best regards,
Ryan

timg's avatar
timg
Solution Sage
5 years ago

Awesome, good to hear!