Gauge visualization not functioning as intended

[WallyWallWal]

Hello!  Newbie here... and first posting!!  

I am trying to get the Gauge visualization to work and am having issues.  I read how to get the total count so that it displays.  

What I am running into is using two charts, and when clicking on one line of my bar chart, the gauge just gives me the total of that bar, not a count of the total.  Looking for any help and/or suggestions!  I was expecting to see 76 of 2185, but didn't get that.  Thank you for the help!

[v-yulgu-msft · Accepted solution]

Hi @WallyWallWal,

Please create two measures similar to:

Actual value = SUM(Table[Sales])

Total of all = CALCULATE(SUM(Table[Sales]),ALL(Table))

Add [Actual value] to 'Value' section of Gauge, add [Total of all] to 'Maximum value' section.

Best regards,

Yuliana Gu

[WallyWallWal]

@v-yulgu-msft If I wanted to change this to a percentage, how do I go about doing that?  Thanks.

[WallyWallWal]

Thanks, @v-yulgu-msft!  This truly helped me out and understand how to create the gauge display correctly.  Appreciate the help!