Calculate filtered by specific Date using selectedvalue

[lbasilio]

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...

[SivaMani]

@lbasilio,

Could you please share some sample data?

It would be helpful to assist you

[lbasilio]

This is my problem, when I use seletevalue in order to filter my measure st_total based on date filtered on dcalendario.

[v-huizhn-msft · Accepted solution]

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