Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
3 years ago

hi

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
Need Help

3 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    3 years ago

    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's avatar
      abc_777
      Solution Specialist
      3 years ago

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

      • abc_777's avatar
        abc_777
        Solution Specialist
        3 years ago

        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