Exclude error Data aggr

[Anonymous]

Hiho friends

have a problem in my report, as there is some not needed data. The problem is that we have sales order lines errors, which are stated with unti price 999999 in the source.

whats the easiest way to exclude the wrong orderline from the line chart? i was just able to cancel the whole month, but not the single order line

Thansk for help

[sunny_talwar · Accepted solution]

May be like this:

Sum({<[Unit Price] -= {99999999}>}[Unit Price] * QTY)

[Anonymous]

try this Expression (Count of 9 correct?):

Sum({<[Unit Price]-={99999999}>}[Unit Price] * QTY)

[Anonymous]

Thanks