Dynamic DAX Selected Measures

[abhiram342]

Hi ,

I'm looking assistance for creating measure based on selected date filter in below scenario

DimDate

DateId	Month
20221001	Oct
20220930	Sep

FactSales

DatedId	Amt
20221001	100
20220930	200

FactSales (DateId) --> DimDate(DateId)

I have date slicer in power BI Chart( example below). I want to create two measures

Measure:

1) Latest Date(based on max selected value):  When I set max date as 20220930 , I should get measure value as 20220930 . when I set max date as 20221001 then I should get value as 20221001.

2) Amount corresponding to select Date:

When I set max date as 20220930 , I should get measure sales value as 100

when I set max date as 20221001 then I should get sales value as 200

Please assist.

Thanks,

Abhiram

[Jihwan_Kim · Accepted solution]

Hi,

I cannot know how your datamodel or how your desired outcome looks like, but please try something like below.

expected result measure: =
VAR _maxdate =
    MAX ( 'Calendar'[Fiscal Date] )
RETURN
    CALCULATE ( SUM ( 'FactSales'[Amt] ), 'Calendar'[Date] = _maxdate )