cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Microsoft

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

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?

1 ACCEPTED SOLUTION
Community Champion

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.

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
3 REPLIES 3
Microsoft

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.

Community Champion

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.

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
Super User

it is a error from floating-point camputation.