Filtering the lowest AIF

[Anonymous]

Hi community,

I've tried some options but as often it happens, I failed..

My table has several lines for each market, but this table has to be exported and fed into another system with only 1 line for each market. The line that i need to keep is the one with the lowest AIF.

I tried some filter solution on the visual but didn't succeed.

any suggestions? 😄

[MariaP · Accepted solution]

HI @Anonymous

If you need to export your table forrm the backend then you can copy and paste your table into the query editor and Use the Basig Group by to Group By Market, Use the Operation  MIn on the AIF Column. This will give you a new table you can use directly in the front end to report on.

New Restricted Table

Or from the front end you can filter using the following measures.

To find the minimun value by Market or ,for example, by Point of Sale City here are 3 measures:

LowestAIF = MIN(Airline[AIF])


Lowest AIF By Market = CALCULATE( [LowestAIF], GROUPBY( Airline, Airline[Market]) )


Lowest AIF By Point Of Sale City = CALCULATE( [LowestAIF], GROUPBY( Airline, Airline[Point Of Sale City]) )

Final results displayed in the front end using the above measures with relevant columns shown:

:

Final results showing values with measures or with a new table

If you need to export the table into another system, the grouping from the backend might work easiest for  you,

Cheers,
Maria