Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

ARTICLESales Last YearSales this yearsales this year if there is sales both this and LY
A100  
B200600200
C 200 
Sum300800300


I am trying to get the red text to be 200. the formula I am using is "sales this year if there is sales both this and LY = IF([Local_fsg Last Year] = 0, BLANK(),  [Local_fsg Current])"

I understand why it is not working but no mater what I do I either get the sum to be empty or it says 300 (as above)

 

can anyone please point me in the right direction? 
thanks

g

1 ACCEPTED SOLUTION

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

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Thank you!

Anonymous
Not applicable

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

 

 

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

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



Anonymous
Not applicable

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:
PowerUserR_0-1662118732079.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.