Sum result of a measure in a table

[Anonymous]

Hi all,

I don't knw if is possible but, i need to sum the result of a measure shown in a table. like this:

As you can see in the table, the result is showing 95% but is wrong, the correct ones should be 75%.

Thanks in advanc

[Anonymous]

Hi @Tahreem24 , I'm using a measure to generate those numbers

This measure:

**bleep**LOBAL = (SUM('predicciones_FV33Pack-GUADA'[Real])/CALCULATE(SUM('predicciones_FV33Pack-GUADA'[Real]),ALLEXCEPT('predicciones_FV33Pack-GUADA','predicciones_FV33Pack-GUADA'[Real])))*[FA]

The data to compose this measure is :

1 column : Measure [FA] (Is other measure no problem with that

2 column : sum row real

3 column : sum total of real

the formula would be (sum(day row day) / sum (total of real))*FA

I think my problem is that is summing all, not just the day an the the result here is 95

[Anonymous]

Any tip?

[v-cherch-msft]

Hi @Anonymous 

You may try to use below measure to get  the total.If it is not your case,please check if below posts could help.If you need further help,please share some sample data which could reproduce your scenario.

https://community.powerbi.com/t5/Desktop/Measure-SubTotals-and-the-Ceiling-function/m-p/625389#M298721

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Measure = SUMX ( Table, [FA])

Regards,

[Anonymous]

Any tip?

[Tahreem24]

Hi,

I got the correct result as 75% in total. See the screen shot below. Please share the data type of this field.