Solved: Re: 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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

AtchayaP · ‎07-12-2022

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

Powerbi percentage dax

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

Be one of the first to start using Fabric Databases.