Forum Discussion

Chaucer's avatar
Chaucer
Helper II
4 years ago

Measure Help

Hi,   I'm trying to create a couple of very basic measures, and for some reason the logic is escaping me.   I've got a very simple data table as follows:   OrderNo OrderDate Parcels EstDi...
Need Help
Chaucer's avatar
Chaucer
Helper II
4 years ago

I tried messing about with Filters using an EARLIER, but that didn't work either....

TestEst =
CALCULATE(
sum('Order Lines'[Parcels]),
Filter(ALL('Order Lines'),
COUNTROWS(Filter('Order Lines', 'Order Lines'[EstDispatchDate] = EARLIER('Order Lines'[Order Date])
)
)))
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, Chaucer 

 

These can be expressed by measure.

If you use measure, change 'EARLIER' to 'selectedvalue'. 

Like:

Total No of parcels ordered by day =
COUNTX (
    FILTER ( ALL ( table ), [OrderDate] = SELECTEDVALUE ( table[OrderDate] ) ),
    [OrderNo]
)

But I don't know how you're going to put the two on a line chart and the logic of ’Trailing 7 day averages of each.‘

Can you explain it?

 

Best Regards,

Community Support Team _Janey

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