Forum Discussion
issue grand total
hey !
Another problem with Grand TOTAL
this is my measure
VAR _SelectedExercice = SELECTEDVALUE(CalendarFiscal[ExerciceComptable])
var _TauxdeMarge = CALCULATE(maxx(Marges,Marges[Valeur]),Marges[Exercice] = _SelectedExercice)
var _TotalCA = [Total_CA]
var _MontantMarge = _TotalCA*_TauxdeMarge
return _MontantMarge
my data
Table DataCA link with table family (dataca.libfam = family.lib.famille)
Table Marge (year, %marge,libFam) (marge.libFam = family.libfamille)
VAR _SelectedExercice = SELECTEDVALUE(CalendarFiscal[ExerciceComptable])
this var is for determinate the good fiscalyear selected
var _TauxdeMarge = CALCULATE(maxx(Marges,Marges[Valeur]),Marges[Exercice] = _SelectedExercice)
this var is too keep the good rate
var _TotalCA = [Total_CA]
this var to keep the "totalrevenue"
var _MontantMarge = _TotalCA*_TauxdeMarge
return _MontantMarge
this var _montantmarge, too have the marge amount
return _montantmarge,
i used a matrix with rows = family.libfamille
i have a slicer with year (calendar table link with dataCA)
at the rows all is correct but the grand total is not correct !
thanks a lot
EdouSav First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
2 Replies
- Greg_DecklerCommunity Champion
EdouSav First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8 - EdouSavHelper I
thanks a lot, I retry this method 🙂