Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am new to PowerBI/DAX but (think) I have a decent understanding of the basics. I run into behaviour I don't understand though:
So with very simple sample data:
I want to display the last date for [model] before the current date. The current date is selected with a slicer:
The measure is set up like this:
Previous Occurence =
VAR selecteddate = SELECTEDVALUE(Data[Date])
RETURN
CALCULATE(
MAX(Data[Date]),
FILTER(
ALL(Data[Date]),
Data[Date]<selecteddate
)
)
I would expect ALL to remove all filters from [Date], but the slicer still seems to be applied. In above screenshot I would expect model A50003 to shop up with date 08/01/2024, but it is blank because the model was not present for the date selected in the slicer.
When I use a separate date table without relationship, it does work like expected:
Would like to understand why this is happening and whether I can achieve this without a separate table.
Thanks!
Solved! Go to Solution.
Hello, I will say it is not possible achieving the desired result without a separate table (for slicer), since the data field used a row and dates are from the same table, for this reason, when a model is not present on the day selected, it will not be displayed in the visual.
Hello, I will say it is not possible achieving the desired result without a separate table (for slicer), since the data field used a row and dates are from the same table, for this reason, when a model is not present on the day selected, it will not be displayed in the visual.
User | Count |
---|---|
91 | |
84 | |
64 | |
62 | |
58 |
User | Count |
---|---|
148 | |
112 | |
95 | |
81 | |
71 |