tool tip calculate percentage for different categories

[MaliniBaktha]

Hi , 

I am facing an issue, I have 4 types of session volumes in two calendar years and I have displaced the values in the stacked column chart . But when I want to look at percentage of the total it calculates the percentages for two calendar year instead of calculating per calendar year . Is there a tool tip for DAX to percentage for the respective category in the calendar years ?

I would like to see percentage of each color category / total in the respective calendar year 

[MaliniBaktha]

@Anand24 thank you it worked 

[Anand24 · Accepted solution]

@MaliniBaktha ,
Try this new measure and pull it into tooltip:

%Sales in a Year = 
DIVIDE(
    SUM('TableName'[Sales]), 
    CALCULATE(
        SUM('TableName'[Sales]),
        ALLEXCEPT('TableName', 'TableName'[Year])
    ),
    0
)