Total of a calculated field values

[Anonymous]

Hello,

Maybe a simple request but I can't manage to find a way to do a total of values I have in my power BI table.

The 4th column on the right below is a result of a formula, I got the value I am looking for for each line but when it comes to total, the formula gives me a result at a global level without taking into consideration the weight of each line.

I'm just looking to have the sum of each line as a total. In this case, I'm looking for a total at - 7 517.  Is somebody can help me ?

Many thanks,

Arnaud

[Datatouille]

Hi Arnaud,

Would you please give us more detail about the formula you used to compute the savings ?

Apparently, it is not fully-additive and it must rely on a Continent context to compute the correct calculation !

Sinon, n'hésite pas à checker notre User groupe français sur Power BI: https://www.meetup.com/fr-FR/Club-Power-BI/ !

[Anonymous]

Hello,

Thank you for your answer.

The formula I used is :

(calculate   (sum('Database v2'[Amount full])   /   sum('Database v2'[Ticket count ])   ;   'Database v2'[Ticket Advance Booking Group 1]="04 to 06 days")

-

calculate    (sum('Database v2'[Amount full])   /    sum('Database v2'[Ticket count ])   ;   'Database v2'[Ticket Advance Booking Group 1]="00 to 03 days"))

*

(0,3   *   calculate     (sum('Database v2'[Ticket count ])     ;     'Database v2'[Ticket Advance Booking Group 1]="00 to 03 days"))

Hope it's readable.

Many thanks,

Arnaud 

[v-yulgu-msft]

Hi @Anonymous,

For 'Savings from shift to 4 to 6 days', rather than creating a measure, is it possible to create a calculated column using the same formula? If add a calculated column into visual, the total row will sum up the values above it by default.

Regards,
Yuliana Gu