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

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 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

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 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 Monthly Update - September 2024

Microsoft Fabric & AI Learning Hackathon

Fabric Community Update - September 2024