Total Line on report of Measure

[Anonymous]

Hi!

I got a question, I put in report some measure and there is a line total and I was wondering what it is?

Because for exemple here, it's not the sum or the mean or the median... Anyone knows what is it? and where we can change it to have the mean for exemple.

Thank you!

[negi007 · Accepted solution]

@Anonymous Total value here is being calcualted at the total data that you have for 2020 + 2021. Formula that is being used for individual year is being used at the total level. Please check your data and try to do the calculation at the total level using the formula for each of the column. 

[Fowmy · Accepted solution]

@Anonymous 

The total line for each measure is calculated independently based on the calculation in the measure. They do not do calculations on the number for 2020 and 2021.

If you need to modify these line values, you can do so by identifying the context line 

IF (  not(isfiltered(Table[Excercice Civil])), [new calculation], [measure] )

 

[Anonymous]

Thank you

[negi007 · Accepted solution]

@Anonymous Total value here is being calcualted at the total data that you have for 2020 + 2021. Formula that is being used for individual year is being used at the total level. Please check your data and try to do the calculation at the total level using the formula for each of the column. 

[Anonymous]

Thank you!