Forum Discussion
Calculate filtered by specific Date using selectedvalue
Hi,
I'm using this and its wotking fine:
SUMMARIZE(ALL(dTanque);dTanque[Parque];dTanque[Produto];"ST";CALCULATE([.ST_Total];FILTER(dCalendario;dCalendario[DataBase]=TODAY())))
But instead of TODAY(), I want to filter depends on the date filter in dcalendario table, or a date filtered on my report, I've tried:
SUMMARIZE(ALL(dTanque);dTanque[Parque];dTanque[Produto];"ST";CALCULATE([.ST_Total];FILTER(dCalendario;dCalendario[DataBase]=selectedvalue(dCalendario[DataBase])))), but it's not working.
Help...
Hi lbasilio,
>>But instead of TODAY(), I want to filter depends on the date filter in dcalendario table, or a date filtered on my report.
Do you mean the selectedvalue(dCalendario[DataBase]) changes with your filter, and the new table you created also changes automatically, right? If it is, we can't achieve it in Power Bi, because it's impossible to create a Calculated Column/Table Change Dynamically According to Slicer Selection in the Report, please review this knowledage base.
Best Regards,
Angelia
3 Replies
This is my problem, when I use seletevalue in order to filter my measure st_total based on date filtered on dcalendario.
Hi lbasilio,
>>But instead of TODAY(), I want to filter depends on the date filter in dcalendario table, or a date filtered on my report.
Do you mean the selectedvalue(dCalendario[DataBase]) changes with your filter, and the new table you created also changes automatically, right? If it is, we can't achieve it in Power Bi, because it's impossible to create a Calculated Column/Table Change Dynamically According to Slicer Selection in the Report, please review this knowledage base.
Best Regards,
Angelia
