Forum Discussion
Multiple Origin Count Calculation
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
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
2 Replies
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