how to make bar graph static

[deeavhad]

my measure expression is as follow, I want to make bar graph static (x axis should be static or does not change as per selection on the page)

Sum({$<[UKI_PPL.Metric]={'FPOC %Without GCP Data'}>}[UKI_PPL.Numerator])/Sum({$<[UKI_PPL.Metric]={'FPOC %Without GCP Data'}>}[UKI_PPL.Denominator])

[rwunderlich · Accepted solution]

Change the "$" set identifiers to "1".

Sum({1<[UKI_PPL.Metric]={'FPOC %Without GCP Data'}>}[UKI_PPL.Numerator])/Sum({1<[UKI_PPL.Metric]={'FPOC %Without GCP Data'}>}[UKI_PPL.Denominator])

-Rob