Hello,
I am currently pulling in static data (goals) into a table from a different data set. The table I am pulling this data into allows the end user to filter by Management Level (slicer = Management levels). I want to somehow connect the static data I am brining into the table to this specific slicer. Any ideas how i can do this? i tried this measure below but it is not functing correctly.
The measure I am bringing into my data source is below:
goal measure =
IF(
ISINSCOPE( Goals[Group]),SELECTEDVALUE(Goals[2021 Female Goal]),if(ISINSCOPE(Goals[Platform]),CALCULATE(sum(Goals[2021 Female Goal]),Goals[IsPlatform]=1)))
this is the measure i used to try and connect my goal measure with the management level filter.
VAR _flag = ISFILTERED('Mgmt Levels'[Management Levels])
VAR _round = IF(_flag,IF(
ISINSCOPE( Goals[Group]),SELECTEDVALUE(Goals[2021 Female Goal]),if(_flag,IF(ISINSCOPE(Goals[Platform]),CALCULATE(sum(Goals[2021 Female Goal]),Goals[IsPlatform]=1)))))
return
_round
