count()
1 TopicFiltering Count by related table
Hi I am trying to filter PA Status so it only calculates the values with the highest status Table Status Sort (related table) PA Status = SUM('Central Scada'[Available]) & " of " & SUM('Central Scada'[Installed]) The highest staus in this example is Red so the PA Status should be 3 of 4 ThanksRodneySolved508Views0likes1Comment