Forum Discussion
Grouping the Hours into a visual when using Live Connection
I am using Switch to group the hours that a job was done. Sample below which returns the values I want, but when I use this measure in say a table visual it only shows values when I include the ori...
With live connection you're limited with what you can do. Only way I can think to get close to what you want is to create separate measures for each group, but I'd need more info on what end result you want displayed (what other fields) to be more helpful here.
A simple COUNTROWS function is what I have in mind, for example:
1 Out of Hours AM Count =
COUNTROWS(FILTER ( 'factUniflowJobDetails' ,
VAR _JobHour = HOUR( 'factUniflowJobDetails'[JobDate] )
RETURN
_JobHour >= 0 && _JobHour <= 7
)
)
And repeat this pattern for the other measures.
Otherwise, this grouping is something that should be done in the source dataset.
Thank you, your response indicates what I thought. I will try the individual measures otherwise go back to the devlopers.
