Progress Percentage subtotals summing to totals

[Khalidshurafa]

I am trying to make a visual in my Power BI dashboard where I included a slicer for an asset called digital zone which has some buildings inside that I included in another slicer.
What I am trying to do is when to click on the asset from the first slicer I need to see the overall progress but when to click on a  building in the second slicer I need to get the progress figures related only to that building.
The issue is that the figures are appearing as a sum (The percentage is becoming more than 100%), 

Can you help me apply the correct filtering and/or DAX formulas

Note : The figures add up based on area weightages out of the total.

[Anonymous]

Hi @Khalidshurafa ,

From your description, the key to resolving this issue is to set up the DAX formula and slicer interactions correctly to ensure that the percentages reflect the proper range of the data.

You should make sure the slicer settings are correct. To view and adjust the slicer interaction, use the Edit Interaction option under the Format tab when selecting a visual object.

Can you provide some example data such as detailed data (without sensitive information) and your desired output. This would allow us to better reproduce and solve the problem you are having.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Khalidshurafa]

Hi @Anonymous 

What I am trying to do is to have to two levels of slicers considering the nature of the project because I have separate building with each of them has its own progress and which all add up to the overall progress of the big asset which I called the digital zone (in the pictures below its digital city)

In fact I have many big assets with each includes small buildings underneath but to simplify I talked only about one.

when I click on one asset from the first slice and then click on one building I can see the progress of that one building which is fine (see the first picture below), but when I remove the selection from the second slicer the progress the visuals return the sum of progress of all the buildings under the asset selceted in the first slicer (see second picture below) which is wrong as I need to see the progress as an overall from the asset not as a sum (from the table below this has to be 55.28% for the planned and 52.98% for the actual).

Just to note that in the data model the buildings are given a key that links them to the asset they come under.

Picture 1

Picture 2

Table