Error while adding month

[anoomohan]

Please help me with below error. 

I am getting this while trying to add month value from Data table to the matrix chart - which contains list of salesman in rows and some measured totals in 3 colums

[anoomohan]

If if correct the desktop file, do i need to republish in service for this measure to be updated?

[anoomohan]

Thank you, it works this way!

[v-cgao-msft · Accepted solution]

Hi anoomohan,

The Number and Multiple arguments must have the same sign (+/-).
Please check the CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year]=2023) part of [2023 SALES B4] for negative numbers.

Use MROUND ( number, SIGN ( number ) * multiple ) if the the sign of the number is not known in advance:

2023 SALES B4 =
VAR __m = CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year]=2023)
VAR __result = MROUND(__m,SIGN(__m)*1000)
RETURN
__result 

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group

[anoomohan]

Below are the 3 measures used in same report - but no error for 2nd and 3rd, not sure why only the first one shows error - 

2023 SALES B4 = MROUND(CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year]=2023),1000)

2024 TGT AFT TR = MROUND(CALCULATE(SUM('AFTER TRANSFER'[Value]), 'DATE'[Year] = 2024),1000)

2024 TGT B4 TR = MROUND(CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year] = 2024),1000)

[Fowmy]

@anoomohan 

It seems your measure [2023 Sales B4] has an issue when you use the MROUND function. check the parameter value you have sed there. Here is the guide: MROUND function (DAX) - DAX | Microsoft Learn