Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
If if correct the desktop file, do i need to republish in service for this measure to be updated?
Thank you, it works this way!
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
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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |