Forum Discussion

Matej's avatar
Matej
Helper I
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Matej 

You cna try tge following measure

[Orders] =
CALCULATE (
    DISTINCTCOUNT ( 'Transaction Lines'[Document Number] ),
    FILTER (
        'Transaction Lines',
        'Transaction Lines'[Type]
            IN { "Credit Memo", "Invoice" }
                && [Revenue] < 25
    )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Matej's avatar
Matej
Helper I
2 years ago

Hi, 

Thanks fo the reply. Unfortunatelly, the last part of the measure ([Revenue] < 25) is being ignored. The measure returns the same values as without that part and I know for sure that there is a number of orders that has smaller revenue. 
The only thing that worked is IF([Revenue] < 25,1,0). This measure correctly marks small revenue orders with 0 but I can't get it to sum total number of those measures.