Hi Team,
I am currently building an SSAS tabular model based on a data model and quite new this space
. The fact table has point in time information based on the change date.
If the user has not selected the date, it should pick the sum of the amount against all other dimensions except for change date dimension where it should pick the latest change date value only.
Here is an example for better understanding.
If the fact table contains below.

If user selects Category and Sales amount, it should do the sum for all the measure except for Change date as below.