Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
JavierGr
Frequent Visitor

Calculated Measure won't update when referenced in a custom table

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.

2 REPLIES 2
mark_endicott
Super User
Super User

@JavierGr - Did this work? Please could you mark it as the solution if yes, this helps other users find it. 

mark_endicott
Super User
Super User

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.