Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX for adding columns correctly

Hi,  I have an Issue with getting the correct sum in a matrix. I think I neet to use sumx in some way but I am unable to get it working ARTICLE Sales Last Year Sales this year sales thi...
Need Help
  • visheshjain's avatar
    visheshjain
    3 years ago

    Hi Anonymous,

     

    Please have a look at the following video, it should be exactly what you are looking for.

     

    Computing totals by summing visible values in DAX - YouTube

     

    Hope this helps and if it solves your problem, then please do mark it as a solution so that others can reach the solution faster.

     

    Thank you,

    Vishesh Jain

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi there PowerUser, 

 

Thanks for taking time to look at my issue. 

 

what I am lookin to do is to force the sum row to actually calculate the sum of the column. The value 200 I get in "sales this year if there is sales both this and LY" is correct but i want the sum row to actually do a sum, not the same formula as the detail rows

 

Is this more clear? 

 

thanks and regards 
G

 

 

visheshjain's avatar
visheshjain
Impactful Individual
3 years ago

Hi Anonymous,

 

Please have a look at the following video, it should be exactly what you are looking for.

 

Computing totals by summing visible values in DAX - YouTube

 

Hope this helps and if it solves your problem, then please do mark it as a solution so that others can reach the solution faster.

 

Thank you,

Vishesh Jain