rounded measure total in table

[hntnxs]

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

[Chihiro]

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.

[hntnxs]

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-msft]

Hi @hntnxs,

Did @Chihiro's solution work? If not, can you provide a sample file?

Best Regards,
Dale