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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ArquimedesP
Helper I
Helper I

Problem selecting a value and show it in a table visual

Hi, i have a problem with a measure. I have this tables :

1) Fecha: has a relation with Desembolsos one to many

2) DateTable :  no related with other tables couse i use it as a filter

Fecha
1/1/2022
1/2/2022
1/3/2022
1/4/2022
1/5/2022
1/6/2022
1/7/2022
1/8/2022
1/9/2022
1/10/2022



3) Desembolsos:

 

ClienteFecha FechaFecha CorrespondienteMonto
11/1/2023

1/1/2023

10
225/1/20231/1/202320
36/4/20231/4/20235
412/12/20231/12/202389
513/1/20241/1/202474
620/2/20241/2/2024588
621/2/20241/2/202455
19/3/20241/3/202466

 

4) Indice de Inflacion: no related with other tables

 

Fechaipc
1/1/20221005
1/2/20221004
1/3/2022800
1/4/2022900
1/5/2022455
1/6/202210
1/7/20222055
1/8/20222025
1/9/20222459
1/10/2022

7156

 

I have a measure based on a date selector, for ex:

 

When I select 01/01/2022 the measure should return IPC 1005

 

 

IPC Dinamico = 
var A = SELECTEDVALUE(DateTable[Fecha])
var B = CALCULATE( SELECTEDVALUE(Indice_de_Inflacion[IPC]), FILTER(Indice_de_Inflacion, Indice_de_Inflacion[Fecha] = A))
RETURN
B

 

 

Then i built a table visual based on "Desembolsos" (which has much more columns), this visual is filtred by Year (Anio_nu) or Month (Mes) and it gives me the expected results, the Fecha IPC filter is independent, but when I put the measure it bring all dates.

 

ArquimedesP_0-1712169886259.png

 

Expected Result (and the value in the total): I need bring the value selected for each rows of the table visual for the filtred dates and also put it at then of the total. How can I achive this? 

ArquimedesP_1-1712170122212.png

 

 

PD: I also used ALLSELECTED, HASONEVALUE, ISINSCOPE and didn't work. 

 

Thanks! 

 

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

Hi @ArquimedesP ,

I create three tables as you mentioned and add relationships among them.

vyilongmsft_0-1712202386049.png

vyilongmsft_1-1712202404555.png

vyilongmsft_2-1712202427219.png

But I do not know where can I add the measure.

vyilongmsft_3-1712202511303.png

Can you provide more about the details? If so, I can do more research on it.

 

 

Best Regards

Yilong Zhou

 

View solution in original post

2 REPLIES 2
v-yilong-msft
Community Support
Community Support

Hi @ArquimedesP ,

I create three tables as you mentioned and add relationships among them.

vyilongmsft_0-1712202386049.png

vyilongmsft_1-1712202404555.png

vyilongmsft_2-1712202427219.png

But I do not know where can I add the measure.

vyilongmsft_3-1712202511303.png

Can you provide more about the details? If so, I can do more research on it.

 

 

Best Regards

Yilong Zhou

 

Hi, thanks for your response. I figured it out using countrows.

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.

Top Solution Authors