Filtering a matrix column by another column or by TopN

ReadTheIron , one of the ways it to add measure like

countrows(filter(Table, [Date Reported] > [Remediation]))

All measure should follow above filter

Or create a column and use that as a visual level filter and filter this column =1

if([Date Reported] > [Remediation] ,1,0)

Hi ReadTheIron !

To solve this issue, you first needs to create a column which calculates either [Date Reported] is greater than [Remediation] or not. You can create calculated column for that purpose using below DAX;

IsDateReport = IF(Table[DateReported] > Table[Remediation], 1, 0)

After this you will need to create a Ranking measure, which will Rank based your column selection like (Common Name, Remediation), this will create Ranking, now you can use this measure to filter out only Top 3 Ranks.

Regards,

Hasham

amitchandak, HashamNiaz , thank you for the help! Unfortunately I run into the same issue when I try either solution - I can't write a measure or a DAX expression that references two tables. Date Reported comes from one table (call it FailureTable), all of the other fields from another (call it AssetTable). The two tables are related many-to-one on Common Name.

So if I try creating a measure, I can get as far as =countrows(filter(FailureTable,FailureTable[Date Reported], but then I can't enter AssetTable[Remediation].

If I try adding a calculated column to AssetTable, I can't enter FailureTable.