How to show total in table using your measure

[dreyes6]

Hello, is this still can be fixed? This is regarding the total is there a way where it shows the correct total? below is my formula.

Total Comm Current YEAR = CALCULATE (SUM(Sheet1[commission] ),FILTER (ALL(Sheet1[date]),

YEAR(Sheet1[date]) = YEAR ( MAX (Sheet1[date]))))

When I select Client B this shows. For the total current year. Just want to show the correct total of 9000 even if it is the measure 

[amitchandak · Accepted solution]

@dreyes6 , I think in this case SUM(Sheet1[commission] )  should work use as date table , join with your date and create this measure if needed

CALCULATE (SUM(Sheet1[commission] ),FILTER (ALL(Date),
YEAR(Date[date]) = YEAR ( MAX (Date[date]))))

[amitchandak · Accepted solution]

@dreyes6 , I think in this case SUM(Sheet1[commission] )  should work use as date table , join with your date and create this measure if needed

CALCULATE (SUM(Sheet1[commission] ),FILTER (ALL(Date),
YEAR(Date[date]) = YEAR ( MAX (Date[date]))))

[dreyes6 · Accepted solution]

Thank you, this will work for now. Appreciate your feedback!!! You are the best