Forum Discussion
Problem with the grand total when using FIRSTNONBLANK function
Hi, I'm having a fact table, where from several reasons there are stored repeated numeric values in one column. I need each value only once, so instead of using SUM('Fact Sales Order'[Quantity]),...
Hi Anonymous,
Try this instead:
MEASURE = SUMX(VALUES('Fact Sales Order'[Quantity]),'Fact Sales Order'[Quantity])
Payeras_BI
Solution Sage
Solution SageHi Anonymous,
Try this instead:
MEASURE = SUMX(VALUES('Fact Sales Order'[Quantity]),'Fact Sales Order'[Quantity])
Thank you so much, you saved me!