Why is Sum() / SumX() returning a value greater than 100%

[jader3rd]

I have the Measure 

MeasureP = SUM(ReplFlush[Count]) / SUMX(ALLEXCEPT(ReplFlush,ReplFlush[Failure]), ReplFlush[Count]) and it is returning a Total of 100.0088%. I find that surprising, it should return 100%. What am I missing?

[jader3rd]

I think that it has to do more with my understanding of when to use ALL vs ALLEXCEPT. Something along the lines of one helps when getting the total for a row vs. the other helps when getting to total for a column.

[CNENFRNL · Accepted solution]

Hi, @jader3rd , indeed, ALLEXCEPT(T, C1, C2...) is tricky,

1. When used as a table function, ALLEXCEPT materializes all the unique combinations of the columns in the table specified in the first argument that are not listed in the following arguments;

2. When used as a modifier in CALCULATE or CALCULATETABLE, ALLEXCEPT removes the filters from the expanded table specified in the first argument, keeping only the filters in the columns specified in the following arguments.

You might to refer to the link for more details.

[wdx223_Daniel]

it is a error from floating-point camputation.