Forum Discussion
Return orders under specific value
Hi guys, I have two defined measures [Revenue] and [Orders]. Is there a way I can filter the [Orders] measure to return only those orders that are below certain [Revenue]? I can do some basic CAL...
Hi,
Thanks for trying to help me. I have used the amended DAX but it seems like the last condition with [Revenue] < 25 (it is 25 in my case) is just ignored. The new measure returns same amount for each client in matrix as:
CALCULATE(
DISTINCTCOUNT('Transaction Lines'[Document Number]),
'Transaction Lines'[Type] IN {"Credit Memo", "Invoice"}
)
