Percentage calculation of groups

[astorey1]

I have a table and I'm trying to create some visuals based on grouping of items. So for example Team 1 is at 98/100 but they belong to unit A. When i use a clustered colum chart for unit A it shows 272/300 instead of 91%. I have tried a few measures but cant seem to get the percentage calculation right for Unit Progress % and Route Progress %. Any help appreciated. Route Unit TeamItem 1 Progress Item 1 Target Item 1 Deadline Item 2 Progress Item 2 Target Item 2 Deadline Red A 1 98 100 20/08/2019 30 100 04/02/2020 Red A 2 75 100 20/08/2019 10 100 04/02/2020 Red A 3 99 100 20/08/2019 40 100 04/02/2020 Red B 4 100 100 20/08/2019 90 100 04/02/2020 Yellow C 5 100 100 20/08/2019 65 100 04/02/2020 Yellow C 6 100 100 20/08/2019 80 100 04/02/2020 Red D 7 75 100 20/08/2019 10 100 04/02/2020 Yellow E 8 100 100 20/08/2019 10 100 04/02/2020 Yellow E 9 100 100 20/08/2019 10 100 04/02/2020 Red D 10 75 100 20/08/2019 10 100 04/02/2020 Red D 11 90 100 20/08/2019 10 100 04/02/2020 Red F 12 95 100 20/08/2019 10 100 04/02/2020 Red F 13 75 100 20/08/2019 10 100 04/02/2020

[EricHulshof · Accepted solution]

Hello,

You want to create a measure for that. 

MeasureName = SUM('Table'[Item 1 progress])/SUM('Table'[Item 1 target])

This way no matter on what you filter the visual it will show the % of the Item 1. You have to create a seperate measure for Item 2. 

 

After you made the measure make sure to set its format to percentage in the modeling tab as can be seen in the screenshot.

Goodluck!

[astorey1]

Thats excellent - so easy!!

Thanks

[amitchandak]

Seems like data has become continuous text.

Please provide same in table format