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')
Go to 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 😊
View solution in original post
@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")))
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.