Forum Discussion
Sum by removing visual filter context
Hi
I have a visual as shown in the picture below. The rows are a buildings "energy grade" which is a letter from A to E and below are the buildings in thos categories. The measure "Sum utleieareal NY" (see below), is the column "Sum utleieareal" in the visual. Now it just sums up the square feet for each building.
The problem is, a building can have multiple classifications. A building can have for examples office spaces with the classification "D" and storage space with the classification "E". This is what is happening for "Berger Omlastningssentral" (First row in D and first row in E). What I want is that the measure "Sum utleieareal NY" gives me the total of thos two which is 1062 + 3621 = 4683.
Anyone know how to do this?
The relationships between the tables are also attached below.
Sum utleieareal NY = SUM('Sertifiseringer alle bygg'[Fordeling areal energimerke])
2 Replies
Anonymous First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, 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
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8Hi
It is not the total which is wrong but the row. I want the two marked rows in the picture below to show the sum of the building "Berger Omlastningssentral". So both rows should show 1062 + 3621 = 4683. It does not show that now because of the building have two different classifications, one which is D and another one which is E. I want the rows to sum up regardless of the classifciation
