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 gauge visual seems to add 1 to the calculated rank. See picture of incorrect gauge, and table above showing calculated rank.
However on the same series, the gauge shows the correct rank:
The fact that the rank returns correctly in the table, and additionally elsewhere in the report on line charts, it makes me think it is something to do with the gauge visual. Does anyone have any ideas?
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.
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:
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.
@v-shex-msft I have made a sample file available on one drive, https://1drv.ms/u/s!AsoxVmjjxqm_i0lQ96jcJK8-W7y0?e=2JULwK
Can you share how you created the gauge visual and the calculated rank?
I noticed your first visual displays the wrong total of rank, just like the gauge visual. I would assume that something is being summed with East of England. Are you using a slicer to filter the data shown in your screenshots?
I would also change the default summarization of rank to "Don't Summarize", because rank is something we generally do not want a total of.
i think your Gauge is showing the total.
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
We are excited to announce the Power BI Super Users!
Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.