Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Subtracting Grouped Rows in Different Tables

Hello,   I'm managing construction locations and I have 2 tables. Here are a few sample columns.   Table 1 (Locations) Work Order # Work Location Tag 7970386 A 7970386 B 7970386 ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hey all,

     

    Thanks for the help. I ended up figuring out the solution. Here's the equation below...

     

    In Progress/Complete Locations = countx(filter('Table1', 'Table1'[Work Order #] = 'Table 2'[Work Order #]), 'Table1'[# of Locations Complete/In Progress])

Not Started Locations = Total Construction Locations - In Progress/Complete Locations
saraMissBI's avatar
saraMissBI
Resolver I
6 years ago

Hi Anonymous 

 

Please find here a pbix file with the solution to your problem.

 

If it solves the issue, please give Kudos and mark as solution.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello saraMissBI ,

     

    Unfortunately the file is stored at alakhawayn365-my.sharepoint.com and I can't access it. Can you post it differently or I can PM you my email address. 

     

    Robyn

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey all,

       

      Thanks for the help. I ended up figuring out the solution. Here's the equation below...

       

      In Progress/Complete Locations = countx(filter('Table1', 'Table1'[Work Order #] = 'Table 2'[Work Order #]), 'Table1'[# of Locations Complete/In Progress])

Not Started Locations = Total Construction Locations - In Progress/Complete Locations
    • saraMissBI's avatar
      saraMissBI
      Resolver I
      6 years ago

      Hi Anonymous ,

       

      Sorry here is the link it should work for you now

       

      Thank you