Multiple Origin Count Calculation

[Anonymous]

Hello all,

New user here, but working with a complex data set. It's a live connection to an AAS model, so unfortunately, I cannot create calculated columns or anything other than new measures. I'm trying to calculate the total number of orders which have multiple origins. So in the below data, the result would be 1, since only 1 order has 2 origins. Order 2 would only have 1 distinct origin, so it wouldn't count. 

Order 1, Origin 1

Order 1, Origin 2

Order 2, Origin 1

Order 2, Origin 1

Any help is appreciated, thanks!

Order 3, Origin 1 

[mahoneypat · Accepted solution]

Please try this measure expression

Orders with >1 Origin =
COUNTROWS (
FILTER (
VALUES ( Orders[Order] ),
CALCULATE ( DISTINCTCOUNT ( Orders[Origin] ) ) > 1
)
)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

That did it, thank you!!!