Forum Discussion

lbasilio's avatar
lbasilio
Regular Visitor
8 years ago
Solved

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 ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

SivaMani's avatar
SivaMani
Resident Rockstar
8 years ago

lbasilio,

 

Could you please share some sample data?

 

It would be helpful to assist you

lbasilio's avatar
lbasilio
Regular Visitor
8 years ago

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's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    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