Forum Discussion
Running Total for Charges
I have a faily simple problem (I think) that i just cant get my head around. We have numerous transaction lines, each with a dollar amount and a truck associated wtih them. I'm trying to do a qu...
Hi, edge9999
You can try the following methods.
Measure 25_150K = SUMX(VW_TICKET_LINEITEMS,[MS_25_150K])Measure OVER150K = SUMX(VW_TICKET_LINEITEMS,[MS_OVER150K])Measure Total = [Measure 25_150K]+[Measure OVER150K]Total = SUMX(FILTER(ALL(VW_TICKET_LINEITEMS),[Unit]<=MAX(VW_TICKET_LINEITEMS[Unit])),[Measure Total])
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.