DAX PRODUCT function bug with different number formats and ALL table

[hohlick]

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:

[v-haibl-msft]

@hohlick

I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 48944945
I’ll post here once I get any update about it.

Best Regards,
Herbert

[v-haibl-msft]

@hohlick

I’ve got response from the Product Team.

It will likely be fixed in the upcoming December release of PBI Desktop.

As a workaround, you can use PRODUCTX(Table1, 0.0 + [Column1]) for now and that should work fine for any data-type of Column1.

Best Regards,
Herbert

[hohlick]

@v-haibl-msft, thank you very much for information and workaround! 

Maxim

[hohlick]

@v-haibl-msft please note that the same behavior is in GEOMEAN function too.