Forum Discussion

saranee's avatar
saranee
Icon for Helper I rankHelper I
8 years ago
Solved

Sum used in expression for sumx

Hi,   We have a dax function Sumx(Table,sum(SALARY)) We are getting like sum of salary for individual country for each row and then multiplied by each times the country appeared in the table.For e....
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi saranee

     

    This is one of the features of CALCULATE.. it transforms ROW CONTEXT into FILTER CONTEXT

     

    To test it....just add these two simple calculated columns in your above TABLE... Both will give different results

     

    Column1 =sum('Table'[Salary])
    Column2=CALCULATE(sum('Table'[Salary]))

     



    Simialry...inside an ITERATOR.... these two expressions behave differently

     

saranee's avatar
saranee
Icon for Helper I rankHelper I
8 years ago

Thanks Zubair for explanation but when I am using Calculate I am not using any filter in it,Sorry I am not having much idea about dax.

Thanks,

Saranee

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi saranee

 

This is one of the features of CALCULATE.. it transforms ROW CONTEXT into FILTER CONTEXT

 

To test it....just add these two simple calculated columns in your above TABLE... Both will give different results

 

Column1 =sum('Table'[Salary])
Column2=CALCULATE(sum('Table'[Salary]))

 



Simialry...inside an ITERATOR.... these two expressions behave differently