My Measure
SelectedRace = IF(HASONEVALUE(Race[RaceID]), VALUES(FACTSectional[RaceID]), BLANK())
Adding a card to a canvas pointing to SelectedRace when I select a different race number the card updates correctly
However in my dynamic table run by DAX the Measure is returning a blank when I reference it and no records are returned However hardcoding the RaceID works
Hardcoding works
VAR SelectedRaceID = 222633
But referencing the measure in the table DAX never picks it up
VAR SelectedRaceID = [SelectedRace]
.
.
.
I am expecting rows returned to the table when I change the selected race but this only works when hardcoding the RaceID. For some reason DAX cant reference the value in the measure