Forum Discussion
Incorrect Productx calculation
I have this equation: =if (contains (RELATEDTABLE('ItemMaster 1'),[ItemGroupPrefix],"Equ"), PRODUCTX(RELATEDTABLE('Invoices 1'), 0.4 * 'Invoices 1'[LineTotal]),0) this looks at a column on a...
If in another column to add PRODUCTX() only, without IF(), is it the same result or not?
In general it's better to have more information about the model, in DAX exactly the same formula gives different results depends on context.
SergeiBaklan The answer to the question - is the ProductX function working without any other expressions is no. i get crazy numbers.