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

[Anonymous]

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.  

[tamerj1]

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

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

[Jihwan_Kim · Accepted solution]

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

[Anonymous]

That works perfectly, thankyou so much 🙂

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