Compare Value in Table and get Higher value

[yuyu18]

Hi, for example I have table name: Stock with 2 columns: Product and Price.
And I have 2 search bar: one I entered A, another will be B.
The result I want it to show is the name of product that have higher Price and in this situation will be B

But I dont know how to do. Please help me

Product	Price
A	2000
B	3000
C	2500
E	3500
F	4000

[yuyu18]

😭

[Anonymous]

Hi, @yuyu18 

What is the search bar in PowerBI that you are describing? As per your description, Slicer suits your needs as well, you can try @talespin approach.

Best Regards,
Yang
Community Support Team

[yuyu18]

😢please help meee

[talespin]

I dont know of search bar, but you can do it with check box. See if this helps.

created two identical tables(no relation). Then created two measures, one for Product and one for Price. Also two slicers each showing Product from two tables(Make sure to enable single selection for slicer).

MaxPriceProduct =

VAR _firstProduct = SELECTEDVALUE(Stock[Product])

VAR _secondProduct = SELECTEDVALUE(Stock2[Product])

VAR _firstProductPrice = CALCULATE(SUM(Stock[Price]), Stock[Product] = _firstProduct)

VAR _secondProductPrice = CALCULATE(SUM(Stock2[Price]), Stock2[Product] = _secondProduct)

return if( _firstProductPrice > _secondProductPrice, _firstProduct, _secondProduct)

---------------------------------------------------------------------------------------------------------------------

PriceProduct =

VAR _firstProduct = SELECTEDVALUE(Stock[Product])

VAR _secondProduct = SELECTEDVALUE(Stock2[Product])

VAR _firstProductPrice = CALCULATE(SUM(Stock[Price]), Stock[Product] = _firstProduct)

VAR _secondProductPrice = CALCULATE(SUM(Stock2[Price]), Stock2[Product] = _secondProduct)

return if( _firstProductPrice > _secondProductPrice, _firstProductPrice, _secondProductPrice)

[yuyu18]

Thank you but I want to take the value from the search bar 😭