Gauge is not displaying the correct values

[gowthamkaveti]

Hi 

I am trying to display the measure of total number of students in a Gauge axis, but it is showing the wrong number of total ( eg., it is displaying the total students as 64000 instead of 94377). 

i have used the following measure :

Total students = 

COUNTROWS('Data Sheet')

*******************************

The actual count of students must be 94377

please see the visual below for reference

the count of students as per my data source sheet 

Please hel;

[gowthamkaveti]

@Ritaf1983 Got it , now it is displaying fine... Thanks alot!

[Ritaf1983]

You're welcome 🙂

[Ritaf1983 · Accepted solution]

Hi @gowthamkaveti 
Please check that you put the measure in the right place :

My pbix with an example is attached.
If it doesn't help Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly