Forum Discussion

ArquimedesP's avatar
ArquimedesP
Icon for Helper II rankHelper II
2 years ago
Solved

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.

 

 

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! 

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

     

    • ArquimedesP's avatar
      ArquimedesP
      Icon for Helper II rankHelper II

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