Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
How would i use the amended time stamp to influence what i saw on a row level
So, i want to only see everything after the amended date
Typically for car A the counts were reduce greatly and only display the results in yellow
Each Car would filter in the same way
Is this possible in this visual
You can use a global filter on the table, but i can’t see how to get each row to present data after a specific event
I have created a test .PBIX but i can’t see anywhere to upload or share it.
Solved! Go to Solution.
Hi, @RichardT_78
You can try the following methods.
Measure =
CALCULATE ( COUNT ( 'Table'[Event description] ),
FILTER ( ALL ( 'Table' ),
[Date] > SELECTEDVALUE ( 'Table'[Ammended time stamp] )
&& [Car] = SELECTEDVALUE ( 'Table'[Car] )
&& [Event description] = SELECTEDVALUE ( 'Table'[Event description] )
)
)
Is this the result you expect? If not, simplify your data and give examples of your desired results.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is perfect and works as expected. I haven’t been using the filter function correctly.
One bit i wasn’t clear on is that the amended date is a measure.
This is the measure I’m using albeit i used a simple example for this question.
time@@ = var _cur_car_table = FILTER(ALLSELECTED('Query1') ,'Query1'[Consist]= MAX('Query1'[Consist])&& 'Query1'[EventId]=1919)
var _t2= ADDCOLUMNS(_cur_car_table,"minus" , ABS([End Date/Time]-NOW()))
var _latest = MINX(_t2,[minus])
var _t3 = FILTER(_t2 ,[minus] = _latest)
return
DATEDIFF(MAXX(_t3,[End Date/Time]),NOW(),HOUR)
This searches essentially through all of the turned off events to find the last one and returns the hours since that event.
I used that following measure to return the amended date , but as a measure
Time since aux on date & time = NOW() - [time@@]/24
do i create a column to use the amended date or can i use a measure in the place of
'Table'[Ammended time stamp]
?
Hi, @RichardT_78
You can try the following methods.
Measure =
CALCULATE ( COUNT ( 'Table'[Event description] ),
FILTER ( ALL ( 'Table' ),
[Date] > SELECTEDVALUE ( 'Table'[Ammended time stamp] )
&& [Car] = SELECTEDVALUE ( 'Table'[Car] )
&& [Event description] = SELECTEDVALUE ( 'Table'[Event description] )
)
)
Is this the result you expect? If not, simplify your data and give examples of your desired results.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
37 | |
31 | |
26 |
User | Count |
---|---|
96 | |
84 | |
43 | |
40 | |
35 |