Forum Discussion
Solved
Filtering 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
ThanksRodney
Hi zenton ,
Here are the steps you can follow：
1. Create measure.
PA Status = var _highest= MAXX( FILTER(ALL('Table Status Sort'), 'Table Status Sort'[Sort]=MINX(ALL('Table Status Sort'),'Table Status Sort'[Sort])),[Status]) return SUMX( FILTER(ALL('Central Scada'), 'Central Scada'[Status]=_highest),[Available]) &" of "& SUMX( FILTER(ALL('Central Scada'), 'Central Scada'[Status]=_highest),[Installed])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi zenton ,
Here are the steps you can follow：
1. Create measure.
PA Status = var _highest= MAXX( FILTER(ALL('Table Status Sort'), 'Table Status Sort'[Sort]=MINX(ALL('Table Status Sort'),'Table Status Sort'[Sort])),[Status]) return SUMX( FILTER(ALL('Central Scada'), 'Central Scada'[Status]=_highest),[Available]) &" of "& SUMX( FILTER(ALL('Central Scada'), 'Central Scada'[Status]=_highest),[Installed])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly