Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with SUMX on Measures Column

Sumx on Measures not working for me   I need a quick dax help here.                       Sales                   Item Col1 Col2 col2 Col4 Col3   DIFF   A 1...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

    Diff measure: = 
VAR _newtable =
    FILTER (
        ADDCOLUMNS (
            VALUES ( Sales[Item] ),
            "@diff", [Col4 measure:] - [Col3 measure:]
        ),
        [@diff] < 0
    )
RETURN
    IF ( HASONEVALUE ( Sales[Item] ), SUMX ( _newtable, [@diff] ) )
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Whether the advice given by Jihwan_Kim  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry