Power BI Gauge Visual Issue

Hi,

Just to confirm, i have checked there is no default summation happening on the rank measure, and this is greyed out to don't summarise.

Apologies, i realised the table i included was probably not that helpful, as it was interacting with all the filters (see a better screenshot below):

As for the calculated rank measure, see DAX below:

Gauge - RankCalc = IF(HASONEVALUE(vLKP_LSOA11_tidy[GeographyName]), RANKX(ALL(vLKP_LSOA11_tidy[ParentGeographyName], vLKP_LSOA11_tidy[GeographyName]), [CalculatedScore], ,DESC))

 

I have set up the gauge, using the above  measure in the value field, and then the maximum is set to the sum of n (which is a column in a table joined that contains the number of areas within the geography type.

 

I have done a new table that includes the calculated score, to confirm the ranking, which confirms the ranking in the above table is correct based on the score.

The calculated score is being calculated using the following DAX:

CalculatedScore = IF([MeasureCode] <= 7, DIVIDE(SUM(IMDTidy[PopulationWeightedScore]), SUM(IMDTidy[Population]),0), DIVIDE(SUM(IMDTidy[PopulationWeightedScore]), SUM(IMDTidy[Population]),0) * 100)

 

I hope that helps, if you need anything else, let me know.

 

Thanks

Steph