Forum Discussion

orghn's avatar
orghn
Icon for Helper I rankHelper 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 = CALCULAT...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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.