The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
20 | |
12 | |
10 | |
7 |