Table selection not reflecting in calculated measure on another chart

[CAPEconsulting]

I have a dashboard as follows: -

And a calculated measure. When I select a category from the table, the bar chart filters to the selction but says 100% for the value of the calculated measure and not the actual answer....

I know I am missing something simple here..Could anyone point it out please

Dashboard overviewCalculated measureAfter slicing from table selection

[v-jiascu-msft]

Hi @CAPEconsulting,

I have tested your formula. It worked properly. Did you use any other slicers or filters? What's in the table that you used to filter? If it looks like ""Albion Park - Macquarie Pass"   Disabled", the result will be 100%. Could you please post snapshot of that table?

Best Regards!

Dale

[CAPEconsulting · Accepted solution]

HI @v-jiascu-msft

I changed my measures to 2 measures: -

DisabledT = SUMX('Disability Total',CALCULATE(SUM('Disability Total'[Count]),FILTER(Disability,Disability[Category] = "Disabled")))

and then

DisabilityT % = [DisabledT] / SUM('Disability Total'[Count])

And now evrutrging works perfcetly across the tables and the charts

Abhijeet