Forum Discussion
DAX Question regarding Measures in Visuals
HI wyattexplore ,
The value of a measure depends on the context, the visual filter will change the context. In your scenario, when you use this measure in a table visual with employee name, the context is based on the employee name, while you are using the line visual with date filter, the context depends on the date.
If you want to display the data of each employee based on the date, we will need to create measure for each employss with the filter [employee_name] = "***"
Best Regards,
Teige
TeigeGao wouldn't there be a way to just have it capture the relevant expected hours? It just seems like that defeats the point of writing a measure, if every time I add an employee to our database I have to go create new measures for each individual. I also don't follow how that measure would look with your reply, could you expand on that at all?
You can also try to add the employee name to the Legend area.
- TeigeGao that's how it is currently set. Any further ideas?