Forum Discussion
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...
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
Hi,
I am not sure that I understand the mathematical logic behind what you are trying to achieve here.
However, based on the name of your column, this would generate the answer:
Sales this year given sales this and last year =
SUMX (
FILTER (
'Table (3)',
EARLIER ('Table (3)'[ARTICLE] ) = 'Table (3)'[ARTICLE]
&& 'Table (3)'[Sales Last Year] <> 0
),
'Table (3)'[Sales this year]
This might be a missunderstanding from my side thought as this returns:
This might be a missunderstanding from my side thought as this returns: