Error while filtering on slicer

[orghn]

Hi Everyone!

I have 2 tables, one with products and the other with laboratories. I need that both blank spaces have the value of the middle one (1514).

The measure is:

Precio_Mio = CALCULATE(MAX(PRECIOS_MENSUALES[PRECIO_ARS]),LABORATORIOS[DLABORATORIO]=SELECTEDVALUE(LABORATORIOS[DLABORATORIO]))

PRECIO_ARS is the price of that product and I have a Lab selected (the middle one) to get only that value. 

This is the sample file: https://www.dropbox.com/s/lb5cl6r4a152gvc/Sample%20Real.pbix?dl=0

[v-yetao1-msft]

Hi @orghn 

The pbix file you provided is deleted , can you provide detail data again ? Also, can you show your needs in the form of data or pictures ? It will help us to deal with the issue easier .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[orghn]

Hi @v-yetao1-msft, 

This is a Sample File:

https://www.dropbox.com/s/jh9ctxatt079dvq/Sample%28Updated2%29%20%281%29.pbix?dl=0

I need to select 1 lab and N products. I need to find the price per month of my product (my_price) and compare to the total_prod_price to find the difference (%) between prices

[amitchandak]

@orghn , Not very clear.

Try like

Precio_Mio = CALCULATE(MAX(PRECIOS_MENSUALES[PRECIO_ARS]),filter(allselected(LABORATORIOS), LABORATORIOS[DLABORATORIO]=max(LABORATORIOS[DLABORATORIO])))

[orghn]

Hi @amitchandak , I tried that but it´s not working. I need to find the price of a specific product (selecting only 1 lab). After that, I should calculate the price of each product of each lab and find the % between my product and the competitors.