Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ivandgreat
Helper II
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 NameContractorStatus
Site1ABCIn Progress
Site2XYZNew
Site3ABCNew
Site4ABCIn Progress
Site5ABCIn Progress
Site6XYZIn Progress

 

ContractorStatusTotal Count% Parent Row
ABCNew125%
 In Progress375%
XYZNew150%
 In Progress150%

 

 

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

 

Thanks in advance.

2 ACCEPTED SOLUTIONS
ribisht17
Super User
Super User

@ivandgreat 

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])
 
ribisht17_0-1656823183534.png

 

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 

View solution in original post

ribisht17
Super User
Super User

@ivandgreat ,

 

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

 

Regards,

Ritesh

View solution in original post

3 REPLIES 3
ribisht17
Super User
Super User

@ivandgreat ,

 

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

 

Regards,

Ritesh

ribisht17
Super User
Super User

@ivandgreat 

 

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

 

Regards,

Ritesh

ribisht17
Super User
Super User

@ivandgreat 

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])
 
ribisht17_0-1656823183534.png

 

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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.