Forum Discussion

orghn's avatar
orghn
Helper I
4 years ago

Error while filtering on slicer

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

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    orghn , Not very clear.

    Try like

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

    • orghn's avatar
      orghn
      Helper I
      4 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.