Dynamic DAX table not updating based on filters

[Anonymous]

Hi all,

I am creating a new table with DAX based on a existing table.

Last_Week_Plan =

CALCULATETABLE(Contracts, DATESBETWEEN(Contracts[Schedule],[Last_Week_Start_Date],[Last_Week_End_Date]))

If you see the formula above the Last_Week_Start_Date and Last_Week_End_Date is coming from the user selection as shown below,

Whenever the user updates the slicer the Last_Week_Start_Date and Last_Week_End_Date is keeps changing but the table is not recalculating and always shows as total row count "306". Why this happens any other alternative solution?

I want user to select the dates where I need to pass it to multiple places, that is why I am doing this way.

Thanks,

Karthik

[v-angzheng-msft]

Hi, @Anonymous 

What is your Count of Activity Name measure? Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?

This measure is not filtered by the filter. Please check the context of the measure.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Can you please guide @Ashish_Mathur ?

[Ashish_Mathur]

Hi,

What is your objective?  Share some data, describe the question and show the expected result.