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.92 or 4.87. I am not sure what I do wrong here. Thank you

Current Trans Cal =
CALCULATE(
COUNTA('Export'[Order Id]),
FILTER('Export','Export'[Non Taxable Total]="5.92"),
FILTER('Export','Export'[Non Taxable Total]="4.87")
)


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

3 Replies

  • 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