Dynamic DAX Selected Measures

abhiram342 — Tue, 25 Oct 2022 03:17:41 GMT

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

Re: Dynamic DAX Selected Measures

Jihwan_Kim — Tue, 25 Oct 2022 03:26:02 GMT

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 )

topic Dynamic DAX Selected Measures in DAX Commands and Tips

Dynamic DAX Selected Measures

Re: Dynamic DAX Selected Measures