topic Re: Calculated Measure won't update when referenced in a custom table in DAX Commands and Tips

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

Anonymous — Fri, 24 Feb 2023 17:30:42 GMT

Hi,
I'm using this method (https://community.powerbi.com/t5/Desktop/How-to-make-measure-dynamic-based-on-DATE-selection-via-Date/m-p/344439#M154450) 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.

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

mark_endicott — Mon, 24 Jun 2024 15:57:40 GMT

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

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

mark_endicott — Thu, 27 Jun 2024 09:47:56 GMT

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