Filtering Count by related table

zenton — Sun, 29 Oct 2023 22:38:18 GMT

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

Re: Filtering Count by related table

Anonymous — Wed, 01 Nov 2023 03:07:04 GMT

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

topic Filtering Count by related table in DAX Commands and Tips

Filtering Count by related table

Re: Filtering Count by related table