Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Anonymous
Not applicable

SELECTEDVALUE alternate result is calculating correctly but not working with filter

I have what i thought was a fairly simple measure to allow a visual to be filtered by selection and default to the current month if nothing is selected: 

 

the measure works as expected if a month is selected, it even returns the correct value if nothing is selected (checked by putting it in a card) but the visual is not filtering to the defult (current) month if nothing is selected.  i made the default month a variable to see if that would fix and it is still not working -  I'm stuck as to what to try next?

 

The Measure: 

Selected Month =
VAR defaultmonth =
CALCULATE (
DISTINCT ( DIM_Calendar[MonthYear] ),
DIM_Calendar[CurMonthOffset] = 0
)
RETURN
SELECTEDVALUE ( DIM_Calendar[MonthYear], defaultmonth )
 
 
 
 
4 REPLIES 4
vapid128
Solution Specialist
Solution Specialist

IF(

DISTINCTCOUNT( DIM_Calendar[MonthYear] )=1,

the correct value,

the defult (current)value

)

Anonymous
Not applicable

i tried this and it didnt work, the card now shows blank if nothing is selected: 

 

Selected Month =
IF (
    DISTINCTCOUNT ( DIM_Calendar[MonthYear] ) = 1,
    SELECTEDVALUE (
        DIM_Calendar[MonthYear],
        CALCULATE (
            DISTINCT ( DIM_Calendar[MonthYear] ),
            DIM_Calendar[CurMonthOffset] = 0
        )
    )
)

IS this what you want?

屏幕截图 2022-06-07 174605.png屏幕截图 2022-06-07 174605.png

 

Anonymous
Not applicable

my measure does that the problem is when the alternate result is returned for selected value it doesnt pass to a filter.   note it is returning the correct value just not filtering.   

 

i tried to simplify the dax to make it easier to trouble shoot - the full measure is here: 

 

SelectedMTD cumulative =
VAR selectedmonth =
SELECTEDVALUE ( DIM_Calendar[MonthYear], CALCULATE (
DISTINCT ( DIM_Calendar[MonthYear] ),
DIM_Calendar[CurMonthOffset] = 0
) )
var SignUpsMTD =
CALCULATE (
DISTINCTCOUNT ( training_contracts[SUT ID ] ),
DATESMTD ( DIM_Calendar[Date] ),
DIM_Calendar[MonthYear] = selectedmonth
)
RETURN
IF (
MAX ( DIM_Calendar[Date] ) <= LASTDATE ( training_contracts[tyims_created_on] ),
signupsmtd,
BLANK ()
)

 

If i select a month it filters correctly: 

thisguy_0-1654822821097.png

if no date is selected it shows all the data: 

thisguy_1-1654822880726.png

 

 

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.