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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
abc_777
Solution Specialist
Solution Specialist

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))
abc_777_0-1684579297938.png

 

 
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
3 REPLIES 3
Thejeswar
Community Champion
Community Champion

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

Thejeswar_0-1684585924551.png

 

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
Solution Specialist
Solution Specialist

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

abc_777
Solution Specialist
Solution Specialist

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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