Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I'm using this method (https://community.powerbi.com/t5/Desktop/How-to-make-measure-dynamic-based-on-DATE-selection-via-Dat... to filter the values in my measures by date and it works perfectly, but when the measure is referenced in a table the table does not display the change made to the measure by the filter.
The measure used for the date:
Dia Variable = MAX('Tabla Calendario'[Date])
The calculated measure using the method to change the date:
M_ECO_6m=
VAR DIA = [Dia Variable]
VAR MOTI = 0+CALCULATE(
COUNT('SB'[ANTIGUEDAD]),
'SB'[ANTIGUEDAD]IN { "+6M" },
NOT('SB'[GC] IN {"GC"}),
'SB'[date_op] = DIA,
'SB'[Description] IN {"MO_ECO"}
)
RETURN MOTI
The table im creating:
M_SB = {("M_Eco",[M_ECO_6m],[%_eco_6m],[M_ECO_X],[%_eco_x],[MO_ECO_G],[%_eco_g])}
when i put the measure in a KPI card it works fine but in the custom table it doesnt update with the filter.
Thanks in advance.
@JavierGr - Did this work? Please could you mark it as the solution if yes, this helps other users find it.
@JavierGr - Calculated tables are static and not dynamic. They are only refreshed when your model refreshes, they do not update with changes of a slicer.
You can use a field parameter if you are looking to switch between different measure results, and if you put measures inside a field parameter they remain fully dynamic.
If this helps, please mark it as the solution.
User | Count |
---|---|
12 | |
11 | |
8 | |
8 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |