Forum Discussion

StephShadwell's avatar
StephShadwell
Frequent Visitor
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

StephShadwell's avatar
StephShadwell
Frequent Visitor
6 years ago

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
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI StephShadwell ,

    I think it may be related to all function, can you please share pbix file with some dummy data for further test?

    Notice: do mask on sensitive data before share.

    Regards,

    Xiaoxin Sheng