Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
EmiliaB_123
Helper II
Helper II

Problems with DAX formula ALL

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!

EmiliaB_123_0-1685535056526.png

 

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.