Forum Discussion
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))
...
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))
