Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

city name in india which have lowest profit

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

2 ACCEPTED SOLUTIONS
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Try this MEASURE

 

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

Regards
Zubair

Please try my custom visuals

View solution in original post

Anonymous
Not applicable

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.

View solution in original post

3 REPLIES 3
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Try this MEASURE

 

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

Regards
Zubair

Please try my custom visuals
Anonymous
Not applicable

Hi,

 

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

 

Thanks,

Sandip

Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.