The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Am making an attendance dashboard , the % of total HC is now giving me % where denominator is Countrows(table) , but i want to change this to give me % of specific category , for example if IC/Manager field is selected to "Manager" and a date 29 Feb is selected ( drop down as "not in office") i want to show the % of Managers not in office on 29th Feb ( and this % shall be upon the total Manager Headcount and not overall headcount ) similarly for other categories such as competency , gender etc. any idea to fix this ?
Solved! Go to Solution.
Hi @RD2235 ,
You do not need to do it for each category since the filter ALLSELECTED will do the calcculation based on the selected categories.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @RD2235 ,
For this ou may need to wrap your countrows in a calculate with the values of the category something similar to:
CALCULATE (COUNTROWS(Table), ALLSELECTED(Table[category]))
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsShall I do teh same for each category ?
Hi @RD2235 ,
You do not need to do it for each category since the filter ALLSELECTED will do the calcculation based on the selected categories.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português