Help with Conditional Formula in Dax

[Anonymous]

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")

)

[timg · Accepted solution]

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]

It worked woohoo. Thank you so much Tim!

Best regards,
Ryan

[timg]

Awesome, good to hear!