Forum Discussion
Solved
Double filter in same table/column
Hi, I have an Excel File with a list of aircraft with the main characteristics of each one (airline, model, manufacturer, age...). I want to identify, per model, which is the position of each air...
Chocapsuro Try:
Aircraft Older Than Measure = VAR __Model = MAX('Table'[Aircraft Model]) VAR __Age = MAX('Table'[Aircraft Age]) VAR __Table = FILTER(ALL('Table'),[Model] = __Model && [Aircraft Age] > __Age) RETURN COUNTROWS(__Table)
Greg_Deckler
Community Champion
Community ChampionChocapsuro Try:
Aircraft Older Than Measure =
VAR __Model = MAX('Table'[Aircraft Model])
VAR __Age = MAX('Table'[Aircraft Age])
VAR __Table = FILTER(ALL('Table'),[Model] = __Model && [Aircraft Age] > __Age)
RETURN
COUNTROWS(__Table)
Hi Greg_Deckler ! Using variables it works perfectly, thank you very much!