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
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

saraMissBI's avatar
saraMissBI
Resolver I
6 years ago

Hi Anonymous ,

 

Sorry here is the link it should work for you now

 

Thank you