Forum Discussion
Chalklands
Helper I
Helper IDivide filtered value by unfiltered value
Hi, I'm trying to achieve the following in BI: I have sales split by category: Meat, Fish, Vegetables I want to calculate a category as a percentage of total sales. How do I prevent the ...
HI
You need to use calculate(sum(x), All(table)) will allow the calculation to happen without filtering the calculation:
If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.
Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com