Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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:
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 23 | |
| 13 | |
| 10 | |
| 6 | |
| 5 |