Forum Discussion
rounded measure total in table
The table below is using a rounded measure. The Total of the AE or NTC column is totaling to 1 even though the individual cells are 0. I'm assuming that the Total is also applying the formula versus a sum of the column numbers. (you can see that the other columns are not all totaling correctly either)
The math is -
01-Bus/Tech: round( (4 * 0.05) , 0) = 0
02-Professional: round( (9 * 0.05) , 0) = 0
03-Manager: round( (2 * 0.05) , 0) = 0
04-Director: round( (1 * 0.05),0) = 0
Assumption
Total: round( (16 * .05) , 0) = 1
Desired outcome is a Total of 0
3 Replies
- Chihiro
Solution Sage
This really depends on how your table is structured.
Assuming that you have... table with individual rows (summarized by Career Band).
Ex:
You can use something like...
Measure = SUMX ( TableName, ROUND ( TableName[Val] * 0.05, 0 ) )
But exact method will depend on your underlying model/table structure.
Thanks for the response - I tried your formula (and I'll admit - I am not familiar with that one) and got some really different results.
Here is the actual formula I've used:
PR_AE/Prob/NTC = round((count(FFile[ID 1 ]) * 'NTC/AE/Prob'[NTC/AE/Prob Value]),0)
It is finding the count based on slicers I've selected on the page and applying the default value of a What If parameter (5%).
v-jiascu-msftMicrosoft Employee
