Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • ribisht17's avatar
    ribisht17
    4 years ago

    Anonymous 

    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 
  • ribisht17's avatar
    ribisht17
    4 years ago

    Anonymous ,

     

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

     

    Regards,

    Ritesh

ribisht17's avatar
ribisht17
Super User
4 years ago

Anonymous ,

 

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

 

Regards,

Ritesh