How to ignore percentage of a category in a table

[sujitjena]

Hi,

I have a table for productivity Hrs by category in one column and perecentage of total in another column. I need to ignore only the percentage for one specific category (Abscence which is 7.8%). Is this possible? Below is the screenshot of my table.

 

My DAX for calculation of percentage is below:

% from SAH = CALCULATE(SUM('Table 1'[Hrs]), ('Table 1'[Category] = "SAH", All('Table 1')

[amitchandak]

@sujitjena , Based on what I got. Try a measure like

divide(CALCULATE(SUM('Table 1'[Hrs])),CALCULATE(SUM('Table 1'[Hrs]), filter(allselected('Table 1') ,'Table 1'[Category] <> "Abscence")))

[sujitjena · Accepted solution]

@amitchandak - Thanks for your quick response. The formula didnt work. But i found the solution. 

I just excluded the category for the numerator and it worked!

Thanks anyway 😊