topic Re: Inject date selection from a dropdown slicer into a dax formula in DAX Commands and Tips

Inject date selection from a dropdown slicer into a dax formula

Netope — Sat, 09 Nov 2024 02:49:56 GMT

Hi I am trying to create a measure that sums Totals for all contracts with EndDate >= the Year/month selected in a slicer dropdown.

See PBI File with additonal explanations.

https://drive.google.com/file/d/1Mb4s79kyTZAUg5WK7EmrK6W7MpGwA4uX/view?usp=sharing

Thanks!

Re: Inject date selection from a dropdown slicer into a dax formula

shafiz_p — Sat, 09 Nov 2024 06:09:23 GMT

Hi Netope Try the below code:

Total = VAR _selectedDate = SELECTEDVALUE('Selected Value'[EndDate]) RETURN CALCULATE( SUM('Selected Value'[Act]), FILTER( ALLEXCEPT('Selected Value', 'Selected Value'[Contract]), 'Selected Value'[EndDate] >= _selectedDate ) )

Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

Re: Inject date selection from a dropdown slicer into a dax formula

Netope — Sat, 09 Nov 2024 22:41:52 GMT

Hi,

Thanks for your reply, I added the formular you suggested but the ourtcome reamins the same, the table only shown contract with end deate in the seclected month.

Any addiotnal ideas?

Thanks!

Re: Inject date selection from a dropdown slicer into a dax formula

Anonymous — Mon, 11 Nov 2024 01:28:53 GMT

Hi Netope ,

You need to create an unrelated dimension table, for which you can view the following results:

Table = SUMMARIZE('Selected Value',[EndDate]) Total = var _s = SELECTEDVALUE('Table'[EndDate]) RETURN CALCULATE(SUM('Selected Value'[Act]),FILTER('Selected Value',[EndDate]>=_s))

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Inject date selection from a dropdown slicer into a dax formula

Netope — Tue, 12 Nov 2024 12:08:25 GMT

Thanks! it worked just fine