Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Incorrect total

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))

MHR88_0-1653314382586.png

Thanks in advance.

  • Anonymous's avatar
    Anonymous
    4 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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