hi

[abc_777]

Hi

I want to make a card visual, Ihave done top 

TOP Product = CALCULATE(SELECTEDVALUE('bm_retail_t product_file'[ITEM_NAME]),

TOPN(1, ALL('bm_retail_t product_file'),[Sale], DESC))

Now I want to make bottom

i tried follwoing but no luck 

Bottom Product = CALCULATE(SELECTEDVALUE('bm_retail_t product_file'[ITEM_NAME]),

TOPN(1, ALL('bm_retail_t product_file'),[Sale], ASC))

please help

[Thejeswar]

Hi @abc_777 ,

I tried this with some simple data, It works fine. There should be something else that is impacting the way this works in your case.

In the below example, Product is a Column, sale is a Calculated Measure

Top_Product = CALCULATE(SELECTEDVALUE(Product_sales[Product]), TOPN(1, Product_sales, Product_sales[sale],DESC))

Bottom_Product = CALCULATE(SELECTEDVALUE(Product_sales[Product]), TOPN(1, Product_sales, Product_sales[sale],ASC))

[abc_777]

same i though as well. anyways thankx man for your time

[abc_777]

i have another issue i am also wondering that one as well can u check if u can solve it if u have time to do so. thx