topic Re: Dynamic value in measure in DAX Commands and Tips

Dynamic value in measure

Anonymous — Mon, 12 Feb 2024 10:37:29 GMT

Total =

var _nl ="

var _selected = CONCATENATEX(VALUES('Commitment Rundown'[Date]),FORMAT('Commitment Rundown'[Date],"dd-mmm-yy"),_nl)

return

CALCULATE(DISTINCTCOUNT('Commitment Rundown'[LTP]),

FILTER('Commitment Rundown',FIND(FORMAT([Baseline Finish WE],"dd-mmm-yy"),_selected,1,-2)<>-2 &&

FIND(FORMAT([RFSU Forecast WE],"dd-mmm-yy"),_selected,1,-2)<>-2))

Hi y'all. Here's the dax formula. And it doesn't work as it should be, because it doesn't get you the selected value inside the formula but only on exit, checked with visual.

Is there any way to do this?

I want to filter out the data so my other two dates [baseline finish] and [RFSU forecast] are in the range of selected date.
It's in same table so the option with the date table joined to main table won't work cause one relationship will be inactive, unless I miss something

Re: Dynamic value in measure

Anonymous — Tue, 13 Feb 2024 03:03:12 GMT

Hi Anonymous ,

Please try the following DAX formula and check if they can solve the problem:

Total = VAR _selectedDates = VALUES('Commitment Rundown'[Date]) RETURN CALCULATE( DISTINCTCOUNT('Commitment Rundown'[LTP]), FILTER( 'Commitment Rundown', 'Commitment Rundown'[Baseline Finish WE] IN _selectedDates && 'Commitment Rundown'[RFSU Forecast WE] IN _selectedDates ) )

Best Regards,

Wisdom Wu

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

Re: Dynamic value in measure

Anonymous — Wed, 14 Feb 2024 09:47:17 GMT

Anonymous
Thank you very much, it works! YAY!!!