topic Re: Measure dynamically in DAX Commands and Tips

Measure dynamically

Anonymous — Wed, 09 Mar 2022 14:35:30 GMT

Good morning guys

I need to create a dax measure for each row of a column of a table dynamically. How to do this?

Observation: I'm doing it like this because I need to describe the values of this dimension in a line chart with the accumulated total. Without creating a measure for each row, I can't show the cumulative total

Thanks is advance

Re: Measure dynamically

BeaBF — Wed, 09 Mar 2022 15:29:46 GMT

Anonymous Hi!

Can you provide sample data on which to calculate the measure and the result you expect to obtain?

Re: Measure dynamically

Anonymous — Tue, 15 Mar 2022 06:30:03 GMT

Hi Anonymous ,

I created some data:

If you want to calculate the cumulative total, you can use the following dax:

Create measure.

accumulated total = CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]<=MAX('Table'[date])))

Result:

Best Regards,

Liu Yang

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

Re: Measure dynamically

Brinki — Tue, 22 Nov 2022 15:42:40 GMT

and what about cummulative totals for last year?