Exam DP-600 topic 1 question 90 discussion

CALCULATE SELECTEDMEASURE more info refer to: https://www.sqlbi.com/articles/using-calculation-groups-to-selectively-replace-measures-in-dax-expressions/

IMHO, Calculate / SELECTEDMEASURE, Source: https://learn.microsoft.com/en-us/dax/selectedmeasure-function-dax#example

since DatesMTD is selecting a range of values from month to the current date, it should be SELECTEDMEASRE SELECTEDVALE is for single value not a range

CALCULATE(Selectedvalue(), DATESMTD('Date'[Date])) combines two DAX functions to achieve a specific result Selectedvalue(): This function returns the value of the currently selected item in a column. It is commonly used in scenarios where you want to retrieve a single value from a column (such as a slicer selection). DATESMTD('Date'[Date]): The DATESMTD function calculates the month-to-date (MTD) total for a given expression. It considers all dates from the beginning of the month up to the current date defined by the filter context. In this case, it operates on the 'Date'[Date] column. Overall Purpose: The entire expression calculates the MTD value for the currently selected item (such as a date) based on the date context. It’s useful for creating dynamic MTD calculations that adjust automatically based on user selections. For example, if you have a measure called “Sales Amount” and you want to calculate the MTD sales amount based on the selected date, this expression would give you that value.