Forum Discussion
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:
| 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!
- Anonymous2 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
- AnonymousNot 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
Helper II
Hi, thanks for your response. I figured it out using countrows.