Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
In my table visual, some of the columns (as circled) are showing the total in the total section but others are showing the last month's value. I am not able to understand this. Can someone please explain it? Also, if I need to show only the last month's value of circled columns (Profit Goal etc.), then how do I show it in totals?
Solved! Go to Solution.
Hi @ashwinijain932 ,
The total in visual is not simply the sum of rows, it is also a calculated value that is affected by the formula.
You could use isinscope() function.
new measure = IF(ISINSCOPE([Month]),[Measure],SUMX(ALLSELECTED(table),[Measure]))
Best Regards,
Jay
Hi @ashwinijain932 ,
The total in visual is not simply the sum of rows, it is also a calculated value that is affected by the formula.
You could use isinscope() function.
new measure = IF(ISINSCOPE([Month]),[Measure],SUMX(ALLSELECTED(table),[Measure]))
Best Regards,
Jay
@ashwinijain932 , you need for force sum from line level
Sumx(Values(Date[Month]), [Your Measure])
refer why my grand total is wrong - https://www.youtube.com/watch?v=ufHOOLdi_jk
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |