Forum Discussion
Helper ISELECTEDVALUE returns value for related dimension, while not present in fact
The issue was resolved by converting the value from BIT to String in the datamodel, such that Power BI would not confuse blank values with FALSE
Super UserMAVIE
SELECTEDVALUE( 'People Engagement'[Rotation] ) is used in in your measure, so where is it coming from in the filter context?
Modify your SUMMARIZECOLUMNS to include the 'People Engagement'[Rotation] field as well
Helper IHi Fowmy
There is a many - one relationship between People Engagement and Date, and People Engagment and Employees. When doing a summarizecolumns over Employees and Date, I would therefore expect SELECTEDVALUE( 'People Engagement'[Rotation] ) to be evaluate in the context of these tables, such that I return the Group by coulmns from the SUMMARIZECOLUMNS function which has a value in People Engagment. This works as intentded if I swap the Rotation boolean column for a text column.
Adding 'People Engagement'[Rotation] to SUMMARIZECOLUMNS does not resolve the issue.
Here is an example of the evaluated measure:
All of these employees are evaluated to false, despite not having an entry in the People Engagement table