How to get a percentage when using slicers

[JayTG123]

Hi all, I am trying to figure out how to get a percentage on the below. 12,474 is Octbers Figure of all data on the two donut graphs (minus HA Imposed Change on the right graph) I would like a percentage of the 12,474 figure so when I select a Organisation from the slicer I see the % of their works against the 12,474 figure... obviously these figures will always change on a monthly basis. Hopefully someone can help! 

Playing around, I done KPI 1 monthly total / KPI1 monthly total which gave me the 100% i was after but obviously when I selected an Organisation from the slicer the % was always 100%. 

Jay

[mattww]

Hi @JayTG123 

To get the bottom number for your % (i.e. the 12,474) so that it doesn't change when you apply a filter to Promoter, you would need to use a CALCULATE measure with an ALL / ALLEXCEPT filter to basically telling Power BI to include the whole table rather than the filtered part of the table.

So, something like

CALCULATE([KPI 1 Total],ALL([PAAs & PAs Received]))

If you wanted this number to still change dependent on a date filter/axis, you might want to use ALLEXCEPT instead. This tells Power BI to ignore all the filters applied to the table, except the one applied to the month column.

CALCULATE([KPI 1 Total],ALLEXCEPT([PAAs & PAs Received],[Month]))

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

[JayTG123]

Hi @mattww thank you for the response! I have added the first formula in and it works for the YTD totals but I would like the percentage of the selected organisation vs the monthly total. So Octobers total is 12,474 and If I select BT Openreach as per screenshot, I get a figure of 1,828. I would like to know the % against the overall monthly figure of 12,474. 

[mattww]

Hi @JayTG123 

So if I'm understanding you correctly, you should already have the measure you need to get your percentage. . .  create the two separate measures which you will then divide to get your %

KPI 1 Selected Org = [KPI 1 Total]

KPI 1 All Orgs = CALCULATE([KPI 1 Total],ALLEXCEPT([PAAs & PAs Received],[Month]))

KPI 1 % = DIVIDE ([[KPI 1 Selected Org],[KPI 1 All Orgs],0)

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

[JayTG123]

Hi @mattww I have created 

KPI 1 All Orgs = CALCULATE([KPI 1 Total],ALLEXCEPT([PAAs & PAs Received],[Month]))

but when i use the slicers (organisation or month) it still updates. So like my screenshot I sent earlier, If I filter BT in Organisation and October in Month I still get the same 1828 figure from that formula. 

[mattww · Accepted solution]

Hi @JayTG123,

Is the Organisation field on a different table? If so, you''ll probably need to apply an ALL to that as well

KPI 1 All Orgs = CALCULATE([KPI 1 Total],ALL(OrgTable),ALLEXCEPT([PAAs & PAs Received],[Month]))

There's probably a more elegant way of doing it, but it's a bit tricky with limited knowledge of how your data is structured

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

[JayTG123]

Thank you @mattww  this solved it!!!