city name in india which have lowest profit

[Anonymous]

Hi,

I need city names in india which have lowest profit and using the below query:

City with lowest profit in India  = calculate(LOOKUPVALUE('Orders'[City],
                         'Orders'[Profit],
                         Min('Orders'[Profit])
                         )
),  'Orders'[Country]=  'India')

and it says that "Column 'Country="India"' in table 'Orders' cannot be found or may not be used in this expression."

Please correct the DAX expression

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this MEASURE

Measure =
MINX (
    TOPN ( 1, FILTER ( Orders, Orders[Country] = "India" ), [Profit], ASC ),
    [City]
)

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this MEASURE

Measure =
MINX (
    TOPN ( 1, FILTER ( Orders, Orders[Country] = "India" ), [Profit], ASC ),
    [City]
)

[Anonymous]

Hi,

Thanks for your reply and it is very helpful to me.

Thanks,

Sandip

[Anonymous · Accepted solution]

HI,

I have used the below query:

City with lowest profit in India = calculate(LOOKUPVALUE('Orders'[City],
                         'Orders'[Profit],
                         Min('Orders'[Profit])
                         )
, FILTER(Orders, Orders[Country]=  "India")
)

and it also works fine for me.