cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Helper II

Calculate Count Parent Child

Dears,

I'm just a newbie using Dax formula or power query.

I have a table which i wanted to get the percentage value based on the parent child relationship.

 Site Name Contractor Status Site1 ABC In Progress Site2 XYZ New Site3 ABC New Site4 ABC In Progress Site5 ABC In Progress Site6 XYZ In Progress

 Contractor Status Total Count % Parent Row ABC New 1 25% In Progress 3 75% XYZ New 1 50% In Progress 1 50%

How could i able to achieve this in simple calculation formula?

2 ACCEPTED SOLUTIONS
Super User

My Video on ALLEXCEPT concept https://youtu.be/fEIaJigVfFg

Step 1

Count of Contractor = count('Count'[Contractor])

Step 2
Total Count per Contractor = CALCULATE(COUNT('Count'[Contractor]),ALLEXCEPT('Count','Count'[Contractor]))

Step 3
Solution Count = DIVIDE('Calendar Table'[Count of Contractor],'Calendar Table'[Total Count per Contractor])

Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
Super User

Did it help, can you mark the post and help the community?

Regards,

Ritesh

3 REPLIES 3
Super User

Did it help, can you mark the post and help the community?

Regards,

Ritesh

Super User

Please close the post so that it will be helpful for others as well

Regards,

Ritesh

Super User

My Video on ALLEXCEPT concept https://youtu.be/fEIaJigVfFg

Step 1

Count of Contractor = count('Count'[Contractor])

Step 2
Total Count per Contractor = CALCULATE(COUNT('Count'[Contractor]),ALLEXCEPT('Count','Count'[Contractor]))

Step 3
Solution Count = DIVIDE('Calendar Table'[Count of Contractor],'Calendar Table'[Total Count per Contractor])

Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users

Announcements

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors