Grand total with axe X and legend

[nasolme]

Hi Community,

How can I adapt my formula so that my grand total is correct according to the type of customer and type of funding

I create a table with the type of funding who is related with my data source

LTV = DIVIDE(

SWITCH(true(), MAX(TYP_FI_TOTAL[TYPE_FINANCEMENT])= "TOTAL", CALCULATE('CALCUL'[TOTAL_EXPO_NETTE],ALL(DATA),'CALENDAR'[Date]),'CALCUL'[TOTAL_EXPO_NETTE]),

SWITCH(true(),

MAX(TYP_FI_TOTAL[TYPE_FINANCEMENT]) = "TOTAL",CALCULATE('CALCUL'[VALO], all(DATA),'CALENDAR'[Date]),'CALCUL'[VALO]))

[nasolme]

Ok. Your answer improve my report *10000. 

Thank u @amitchandak 

[amitchandak · Accepted solution]

@nasolme , Are you trying something like this

https://amitchandak.medium.com/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be