value is well valued in one report but taking it with formula from another report increases the value

[sarroyave]

Hello everyone, I hope this very well, I present the detail of the case you mentioned in the title:

The total in an Ej total sales report is correct in a total summary in a card (in millions) but when you take that value for a formula in another tab with another report that has different que quens, this value is increased as 70 times and that is why it rises to trillions.

To try dat a clearer example:

On the tab called Sales total sales says for example: 1,679.45M

In the variation tab I do not have that value I try to take by formula to calculate the % of variation as well:

Variation (DIVIDE(SUM(ReportVariation[Total lines]), SUM(Sales Report[Total Value]) - SUM(Sales Report[Gross Contribution]),BLANK()))*100

Which does not give me and is because when going into more detail and testing the values of the columns that come from the report of the sales tab are already altered with if they were adding back 70 times approximately, giving a value in billions

I appreciate your support

[parry2k]

@sarroyave really not fully sure about your question. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[sarroyave]

Hello everyone, I hope this is very good, I have the following problem:

The total in a report Ex total sales is given correct in a total sum in a card (in millions) but when that value is taken for a formula in another tab with another report that has different queries, this value is increased by 70 times and that's why it rises to billions.

To try to give a clearer example:

In the tab called Sales, the total of sales says for example: 1.679.45M

In the variation tab that I do not have that value I try to take it by formula to calculate the% of variation like this:

variation = (DIVIDE (SUM (VariationReport [Total lines]), SUM (SalesReport [Total Value]) - SUM (SalesReport [Gross Contribution]), BLANK ())) * 100

Which does not give me and it is because when I go into more detail and test the values ​​of the columns that come from the report of the sales tab, they are already altered with if they were being added again approximately 70 times, giving a value in billions

Thank you for your support