Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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]),...
DAX
firstnonblank
  • Payeras_BI's avatar
    Payeras_BI
    4 years ago

    Hi Anonymous,

    Try this instead:

    MEASURE = SUMX(VALUES('Fact Sales Order'[Quantity]),'Fact Sales Order'[Quantity])

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
4 years ago

Hi Anonymous,

The solution could be again on iterating those dates and then adding up. A variation of the formula already provided would do it. 

In case you wanted further help, please provide enough details to reproduce your scenario.