Problem selecting a value and show it in a table visual

ArquimedesP — Wed, 03 Apr 2024 18:49:56 GMT

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:

Cliente	Fecha Fecha	Fecha Correspondiente	Monto
1	1/1/2023	1/1/2023	10
2	25/1/2023	1/1/2023	20
3	6/4/2023	1/4/2023	5
4	12/12/2023	1/12/2023	89
5	13/1/2024	1/1/2024	74
6	20/2/2024	1/2/2024	588
6	21/2/2024	1/2/2024	55
1	9/3/2024	1/3/2024	66

4) Indice de Inflacion: no related with other tables

Fecha	ipc
1/1/2022	1005
1/2/2022	1004
1/3/2022	800
1/4/2022	900
1/5/2022	455
1/6/2022	10
1/7/2022	2055
1/8/2022	2025
1/9/2022	2459
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.

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?

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

Thanks!

Re: Problem selecting a value and show it in a table visual

Anonymous — Thu, 04 Apr 2024 03:50:06 GMT

Hi ArquimedesP ,

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

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

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

Best Regards

Yilong Zhou

Re: Problem selecting a value and show it in a table visual

ArquimedesP — Mon, 08 Apr 2024 19:14:36 GMT

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

topic Re: Problem selecting a value and show it in a table visual in DAX Commands and Tips

Problem selecting a value and show it in a table visual

Re: Problem selecting a value and show it in a table visual

Re: Problem selecting a value and show it in a table visual