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 t...
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
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
That did it, thank you!!!