Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
For the simple table with one column:
Column1 1 2 3 4
PRODUCT function returns different results, depending on number format in Column1:
Whole Number:
Currency:
and only with standard Decimal format it works as prescribed:
This measure:
=CALCULATE(PRODUCT(Test[Column1]),ALL(Test))
and its PRODUCTX companion also return wrong results with whole or currency number formats:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.