Forum Discussion
Measure + Wrong Grand total
Hello, I have a measure that works fine until it gets to the grand total. I get 2 992 019$ but it should be 2 518 283$ (See: 1-Result).
The problem is with "Paramètre_Contingences" (See: 2-Table). It applies 0,05 for Contingences/Incidences and 1 for Crédit général, but when it gets to the Grand total it applies 1 to both, which is wrong.
Any ideas? My measure is in 3-Measure.
Thank you
1- Result
2- Table
3- Measure
1 Reply
- lbendlin
Super User
You can use ISINSCOPE to sense where in the visual your measure is and then adjust the measure accordingly.
But there is a better way. As the saying goes "Think like the Grand Total" - that way your measure will work for all scenarios.
