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...
Solved! Go to 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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
197 | |
68 | |
61 | |
58 | |
56 |
User | Count |
---|---|
189 | |
166 | |
87 | |
73 | |
70 |