Forum Discussion
MAVIE
Helper I
Helper ISELECTEDVALUE returns value for related dimension, while not present in fact
I am creating the following measure, which has to returns a value from my fact table based on different scopes. DEFINE MEASURE 'People Engagement'[Engagement Rotation] = VAR YearInScope = ...
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
