List of accounts with >= $5,000 in at least one of five fiscal years

[PBrainNWH]

I want to be able to show a list of accounts and giving amounts where account giving totals are at least $5,000 in one of the fiscal years. So, >= $5,000 in FY2023 and/or FY2022, and/or FY2021... I do not want to list the account if they do not have a giving total of at least $5,000 in any of the shown fiscal years.

[amitchandak · Accepted solution]

@PBrainNWH , Try a measure like this or use this measure in visual level filter

Countx(Filter(Summarize(Table, Table[Account], Table[FY], "_total", [Total measure]), [_total]>5000), [Account])