Percentage Number Visual Issue

[PPars2025]

I am wanting to have a visual that represents each employee's audit percent to goal.  Regardless of using the Guage or Card visulization, when I have not selected a store number, the PCT. To Goal visual is showing a either 100% or when I change to show the value as no calculation it's then showing a grand total of all percentages. 

This images show's what the visual is correctly displaying an accurate percentage:

This is view of my dataset:

This visual is showing a total of all percentages:

This visual is showing a 100% regardless of which store I select:

[v-junyant-msft]

Hi @PPars2025 ,

Agree with Ashish_Mathur, We really don't quite understand what you're trying to say about the problem you're having, and the data you've provided is incomplete and the desired outcome is not clear enough for us to know what the problem is. Please provide us with a more detailed description, more complete sample data and your expected results. Thank you!
How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,
Dino Tao

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  Show the expected result there clearly.