Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How iterator function deal with the first argument

Hi, all.   Please help me to understand how to use iterator function.   Iterator functions such as sumx need 'table' as first argument.   But, I don't understand well that 'table' wil...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    A simple SUM() function should work there.  You do not need a SUMX() function at all.  If you realy want to use the SUMX() function, then try these measures

    Total = SUM('Fact_001_Qty'[Qty])

    sumx2 = SUMX(VALUES('Fact_001_Qty'[Product]),[Total])

    To your visual drag Category and sumx2 measure.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ashish_Mathur 

I apriciate your answer.


I can get expected result as following your advise.

 

Could I ask additional question about it?

 

Why do I get that result by just using SUM function?

I think that context transition may occur, is it corret?

 

I mean that 'VALUES('Fact_001_Qty'[Product])' generate row text by non-repeated Product at first

and then context transiton occurs into filter context , finally SUM is calculated by Product.

 

I really appreciate if you could correct me if I'm wrong.

 

Best regards