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
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Anonymous,

Try this instead:

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

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Payeras_BI,

 

I'd like to ask you, if you could help me with one problem related to the issue above. I'm making snapshots of Sales Order Quantity on specific dates. I found out, that the quantities don't sum up through the Snapshot Date dimension:

On these two dates quantities were the same, which is right, but the Grand total is wrong.

 

I would appreciate any advice

Thanks in advance! And thank you one more time for helpnig me out with the previous issue!