Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Alejandro_LS
Frequent Visitor

UNIR TABLAS DE PARAMETROS

Parametros.JPG

 

 

 

Se han definido 2 parametros. Como puedo crear una tabla que sea la union de las selecciones que se hicieron para ambos parametros

1 ACCEPTED SOLUTION
v-yilong-msft
Community Support
Community Support

Hi, @Alejandro_LS 

Based on the information you have provided, Here are my answers to your questions.

  1. Create TABLA1 and TABLA2.

vyilongmsft_6-1703575392316.png

vyilongmsft_1-1703575250339.png

 

  1. Create an Enter parameter to filter the rows in the two tables you need.

vyilongmsft_2-1703575250339.png

vyilongmsft_5-1703575348421.png

 

 

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

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

View solution in original post

5 REPLIES 5
v-yilong-msft
Community Support
Community Support

Hi, @Alejandro_LS 

Based on the information you have provided, Here are my answers to your questions.

  1. Create TABLA1 and TABLA2.

vyilongmsft_6-1703575392316.png

vyilongmsft_1-1703575250339.png

 

  1. Create an Enter parameter to filter the rows in the two tables you need.

vyilongmsft_2-1703575250339.png

vyilongmsft_5-1703575348421.png

 

 

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

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

Hola
Muchas gracias por tu respuesta
Me falto incluir en la solicitud, que lo que preciso es una solucion a nivel DAX, para que el usuario pueda interactuar a nivel browser, no a nivel Desktop. 
Igualmente muchas gracias, porque voy a analizar el Script de esta solucion para ver si puedo de ahi tomar idea para aplicarlo en el nivel DAX

 

Saludos

Ahmedx
Super User
Super User

explain why you need to choose A-30, B-200
what is the logic here

Las selecciones A-30, B-200 son solo un ejemplo de seleccion para cada parametro

Lo que preciso es luego de haber hecho esa seleccion, crear una nueva tabla que solo contenga esas filas y poder modelar a partir de esa nueva tabla

 

Saludos

Is this what you are looking for?

watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RjEjfpEl-ycDnFp5b?e=PH1se7

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.