Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
16 | |
10 | |
8 | |
8 | |
7 |