Figure in Visual is higher than than original data / power query

[ameenul]

Need help to advise why my visual display a much higher figure than my original dataset.

Example:

The sales displayed in my data is $642,880.68 however when displayed at visual card it displayed as $ 4,659,790.00 instead.

Appreciate anyone help on this. TQ

[ameenul]

Hi  @Ashish_Mathur  , Thank you for your feedback.

The following are the details of the issue with a different example:

For Burger Slave, we can see the Rental Chargable amount on 01 January 2023 is $ 178, 899.16

However this is different as per the table view:

But if I were to separate it, I would get the correct information:

Could it be the issue with how I manage the relationship?  

[vanessafvg]

morning likely,  can you show a view of your relationship diagram?

[ameenul]

@vanessafvg , Tq for your response. I hope the following screenshot is what you meant: 

[ameenul]

I hope this link to my file helps   

https://drive.google.com/file/d/1M3eydlEfLR6hKjkIPTocOY3RL9pb1Usm/view?usp=drive_link

[Ashish_Mathur]

Access denied message.

[Ashish_Mathur]

I will need a file to be able to offer any help.

[ameenul]

https://drive.google.com/file/d/1M3eydlEfLR6hKjkIPTocOY3RL9pb1Usm/view?usp=drive_link

[Ashish_Mathur]

Hi,

Just with that much information, nobody can help you.  Share the download link of the PBI file and show the problem very clearly.