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

timg's avatar
timg
Solution Sage
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!