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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |