The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello everyone,
I have an issue with a DAX formula where I would like to calculate a percentage that doesn´t consider the filters for one value in the formula. I want to show the CO2 emission from electricity as a percentage from the entire CO2 emission. In the report there is also a list of all the companies, so I would like to also be able to filter one company and then it adjusted this percentage value showing the percentage of this one company compared to the entire emission. For this I used "ALL" function in DAX that should neglect the filtering. But it isn´t working. I can see for now the 94% as a percentage overall but when I click on an entity the percentage value switches to 100% not considering to calculate the emission from the one company compared to the entire emission. I am sure something is wrong with my formula, but I said it up as described in the DAX guidance of Microsoft and I don´t know how to change it.
Thanks in advance for your feedback!
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |