Forum Discussion
Power BI Gauge Visual Issue
I am using the gauge visual to display a calculated measure of the rank of a score, with the max value set to the number of areas. This seems to be working fine with some areas, but sometimes the ga...
Hi StephShadwell ,
I think it should more be related to your filters you set in measure formula, it seems like its calculations only interact with specific fields. Can you please share you measure formula with some sample data? It is hard to troubleshoot your issue without any data.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
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