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.
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.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |