HI,

I have 50 local authorities and I want to get and display at the same time what each of them contributed in percentage and the overall percentage. Such that if you select a local authority its contribution vs overall contribution should displayed at the same time. Example

Local government name is Jos

what Jos contributed is 35%

Overall contribution of the remaining 49 local governement is 80%

How can I write a DAX formula to calculate the above problem

Thanks,

Chukliz