Forum Discussion
Grand Total without Filter
I am trying to add a contribution % to my table. I managed to get the Grand Total (eg 1,000,000) to repeat on the rows. I then did a Divide formula and it is working fine. However, I only wanted to display the Top 10 brands and when I did that, my contribution changed as the Grand Total is now reflecting only for the Top 10 brands (eg 800,000). How can I fix my Grand Total formula to include all and not AllSelected.
5 Replies
Anonymous , You can create a new measure with all
example
M1 = calculate([contribution %], all(Table))
Then you can use isinscope to switch the filter
if(not(isincope(Table[Brand])) , [M1], [contribution %])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Hi Anonymous
Could you provide
(1) a sample file, you can replace raw data with bogus data to protect your privacy,
(2) or provide some sample data that fully covers your issue.
(3) Please show the expected outcome based on the sample you provide
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
ok, if you need more help, you can still @ me to reply this post.
If you have ideas to solve this question, you can also share them, and then we can close the thread. Thanks ❤️
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
