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 = CALCULAT...
Need Help
VahidDM's avatar
VahidDM
Super User
4 years ago

Hi orghn 

 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

orghn's avatar
orghn
Helper I
4 years ago

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]))