Forum Discussion
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...
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.
Ashish_Mathur
Super User
Super UserHi,
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.