Incorrect total

[Syndicate_Admin]

Best regards! Help! Help!

I have this case, each item has a budget and real sale per month, to calculate the adhesion I have to condition, if the budget is greater than the shipping, then the shipping counts, otherwise the budget.

I have the following code, but the total is incorrect, in the end a comparison of the result of the model vs calculated in excel.

Countable = SUMX(VALUES('Style by Make'[Assembly Style]),

Where _Budget = Calculations[Budget]

Where _Shipping = Calculations[Shipping]

Return

IF(_Budget>_Shipping,_Shipping,_Budget))

Thanks in advance.

[v-yangliu-msft · Accepted solution]

Hi  @Syndicate_Admin ,

I created some data:

When the total is incorrect:

Here are the steps you can follow：

1. Create measure.

Total is correct =
var _table=SUMMARIZE('Table','Table'[Group],"_value",[Total is incorrect])
return
IF(HASONEVALUE('Table'[Month])&&HASONEVALUE('Table'[Group]),[Total is incorrect],SUMX(_table,[_value]))

2. Result:

If you need pbix, please click here.

Best Regards,

Liu Yang

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

[amitchandak]

@Syndicate_Admin , You need a measure like this. Use all columns in visual

Sumx(summarize(Table, Table[Month], Table[Second Column], "_1", [Countable]), [_1])