Forum Discussion
Help: Who has time at a specific Date?
- Anonymous4 years ago
Hi Dacja ,
I updated my sample pbix file(see attachment), please check if that is what you want.
1. Create a measure as below to judge if the resource is available
Flag = VAR _seldate = SELECTEDVALUE ( 'Date'[Date] ) VAR _selresource = SELECTEDVALUE ( 'Resource'[Resource No.] ) VAR _wresources = CALCULATETABLE ( VALUES ( 'Forecast Entry'[Resource No.] ), FILTER ( 'Forecast Entry', 'Forecast Entry'[Date] = _seldate ) ) RETURN IF ( NOT ( _selresource IN _wresources ), 1, 0 )2. Create a table visual and apply a visual-level filter with the condition(Flag is 1)
3. Hide the field Flag of the visual by toggle off the option "Text wrap" and adjust the size of the field
Best Regards
Hi Dacja ,
I updated my sample pbix file(see attachment), please check if that is what you want.
1. Create a measure as below to judge if the resource is available
Flag =
VAR _seldate =
SELECTEDVALUE ( 'Date'[Date] )
VAR _selresource =
SELECTEDVALUE ( 'Resource'[Resource No.] )
VAR _wresources =
CALCULATETABLE (
VALUES ( 'Forecast Entry'[Resource No.] ),
FILTER ( 'Forecast Entry', 'Forecast Entry'[Date] = _seldate )
)
RETURN
IF ( NOT ( _selresource IN _wresources ), 1, 0 )
2. Create a table visual and apply a visual-level filter with the condition(Flag is 1)
3. Hide the field Flag of the visual by toggle off the option "Text wrap" and adjust the size of the field
Best Regards
Works like a charm, THANKS!