Solved: Powerbi percentage dax

AtchayaP · ‎07-12-2022

hi, can I know how to calculate percentage for this data . I want to calculate also for 47595 , 12828 as grand total

amitchandak · ‎07-12-2022

@AtchayaP , Assume you have two measure Employee has skill and Count of active directory ID

Create a new measure

= divide([ Employee has skill],[Count of active directory ID])

You can mark that % measure using measure tool

!! Integrated Course on Microsoft Fabric, Power BI, and SQL for Free!! !! Master Microsoft Fabric- 31 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎07-12-2022

@AtchayaP , Assume you have two measure Employee has skill and Count of active directory ID

Create a new measure

= divide([ Employee has skill],[Count of active directory ID])

You can mark that % measure using measure tool

!! Integrated Course on Microsoft Fabric, Power BI, and SQL for Free!! !! Master Microsoft Fabric- 31 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

AtchayaP · ‎07-12-2022

If I have one columns as skill count how to find percentage

Powerbi percentage dax

Helpful resources

Power BI September 2023 Update

Learn Live: Event Series

Exclusive opportunity for Women!

Power Platform Conference-Power BI and Fabric Sessions