Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello.
I never used DAX and could not find a proper solution a surely easy question.
I have a measure with the total sales. In a table I also have a column with the sales of each shop. I need to discard some shops, but we have to compare with the total. If I filter some shops, the total chances, but I need to use the total even of the discarted shops.
So, how can I configure a column with the formule "previous column / Totals measure"?
Thanks
Solved! Go to Solution.
Hi @Anonymous
You need to do simething like
Totals measure =
CALCULATE ( [Sales], ALL ( TablrName[Shop] ) )
Ofcourse it depends on the filter contectx of the table visual i.e. what other columns involved in the table.
@Anonymous Use ALL. You will likely need to have a slightly different calculation for your total line. 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
Thank you!!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |