Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
IF(
DISTINCTCOUNT( DIM_Calendar[MonthYear] )=1,
the correct value,
the defult (current)value
)
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?
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:
If i select a month it filters correctly:
if no date is selected it shows all the data:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |