topic Re: SELECTEDVALUE alternate result not passing to filter - is there a way to do this? in DAX Commands and Tips

SELECTEDVALUE alternate result not passing to filter - is there a way to do this?

Anonymous — Wed, 15 Jun 2022 04:42:50 GMT

I posted this previously but i don't think i was able to explain my problem correctly - I would like the signups vs target visual to show the latest month if nothing is selected in the signups by month visual - it currently shows the full history if nothing is selected.

PBIX with sample data:

https://drive.google.com/file/d/1khDD9vZDYgV14BDx-Ti1nJiStQGsrmGM/view?usp=sharing

if you select a month in the first visual the second visual filters correctly - if nothing is selected the second visual should show May (as per the selected month card) but it shows all months.

Re: SELECTEDVALUE alternate result not passing to filter - is there a way to do this?

Jihwan_Kim — Wed, 15 Jun 2022 05:47:14 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below measures and the attached pbix file.

SelectedMTD cumulative = VAR _maxdate = CALCULATE ( MAX ( Volumes[original_received_date] ), REMOVEFILTERS () ) VAR _maxmonthyear = MAXX ( FILTER ( ALL ( DIM_Calendar ), DIM_Calendar[Date] = _maxdate ), DIM_Calendar[MonthYear] ) VAR _mtdmeasure = CALCULATE ( SUM ( Volumes[count per day] ), DATESMTD ( DIM_Calendar[Date] ) ) VAR SignUpsMTD = SWITCH ( TRUE (), CALCULATE ( COUNTROWS ( VALUES ( DIM_Calendar[MonthYear] ) ), ALLSELECTED () ) = 1, _mtdmeasure, CALCULATE ( SUM ( Volumes[count per day] ), DATESMTD ( DIM_Calendar[Date] ), DIM_Calendar[MonthYear] = _maxmonthyear ) ) RETURN SignUpsMTD

Target MTD = VAR _maxdate = CALCULATE ( MAX ( Volumes[original_received_date] ), REMOVEFILTERS () ) VAR _maxmonthyear = MAXX ( FILTER ( ALL ( DIM_Calendar ), DIM_Calendar[Date] = _maxdate ), DIM_Calendar[MonthYear] ) VAR _mtdmeasure = CALCULATE ( SUM ( Targets[Target] ), DATESMTD ( DIM_Calendar[Date] ) ) VAR SignUpsMTD = SWITCH ( TRUE (), CALCULATE ( COUNTROWS ( VALUES ( DIM_Calendar[MonthYear] ) ), ALLSELECTED () ) = 1, _mtdmeasure, CALCULATE ( SUM ( Targets[Target] ), DATESMTD ( DIM_Calendar[Date] ), DIM_Calendar[MonthYear] = _maxmonthyear ) ) RETURN SignUpsMTD

Re: SELECTEDVALUE alternate result not passing to filter - is there a way to do this?

Anonymous — Wed, 15 Jun 2022 05:55:31 GMT

That works perfectly, thankyou so much 🙂

I thought i was close to working it out, but this is very different to my attempt 😕

Re: SELECTEDVALUE alternate result not passing to filter - is there a way to do this?

tamerj1 — Wed, 15 Jun 2022 08:10:39 GMT

Hi Anonymous
Here is another way of doing that similar to yours

https://www.dropbox.com/t/OUOkIshFtRXkSqKf