Forum Discussion
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...
Hi VahidDM , I send you sample data and tables, I can´t share the file due to privacy.
Data:
Product 1 from Lab a price 10
Product 2 from Lab b price 15
Product 3 from Lab c price 20
I need to select a Lab in the slicer, for example Lab b and I need a table with an output in EACH ROW with value 15
this values in yellow should be 15
This is my dax:
Precio_Mio = CALCULATE(MAX(PRECIOS_MENSUALES[PRECIO_ARS]),LABORATORIOS[DLABORATORIO]=SELECTEDVALUE(LABORATORIOS[DLABORATORIO]))
Hi VahidDM . I attach a sample file https://www.dropbox.com/s/okd4v27jqk1ddt0/Sample.pbix?dl=0 .
Hope it´s clearer now!