summarize a measure that it is calculated with formulas

[dobregon]

Hi,

It need some help if exist something that i can do in DAX.

I have a table with daily values. Then i have created a measures that calculate day by day (it is not possible in a column of the table, should be a measure). So, for the daily values are ok in the matrix visual

but the problem is when I create other matrix visuals only at year, monthl level, because the measure is calculating the values according to de aggregation at yearly,monthly level. What i need is when i aggreate at monthly or yearly level, give me the sum of the values of the calculations at daily level, not claculate again.

is it something possible in DAX?

[Anonymous]

Hi @dobregon,

According to your deduction, It sounds like a common multiple aggregation requirement on measure expression.
For this scenario, you need to add a variable with summarize function to do the first aggregate, then use the iterator function on the parameter table to apply the second one.

For N level aggregates also can be worked with the same logic, you can use variables and nested summarize functions with the previous result to apply next level aggregate and finally use an iterator function to summary table records to one to apply the last level aggregations.

Regards,

Xiaoxin Sheng

[d_gosbell · Accepted solution]

Yes this is possible. You would do this using the SUMX function.

Something like:

SUMX( VALUES( 'Date'[Date] ),  <your expression here> )