Forum Discussion
Single Slicer?
I have this data: So as you can see, a company can have a Cobra manager, a Flex manager, or both. For the most part it tends to be the same person, but there are some exceptions. Is there ...
You could use an unrelated person table and a measure like this:
Measure = VAR myPerson = IF(HASONEVALUE(People[People]),SELECTEDVALUE(People[People]),BLANK()) RETURN IF(myPerson IN ALLSELECTED(COBRA[COBRA AM]) || myPerson IN ALLSELECTED(COBRA[Flex AM]),1,0)
You could use an unrelated person table and a measure like this:
Measure = VAR myPerson = IF(HASONEVALUE(People[People]),SELECTEDVALUE(People[People]),BLANK()) RETURN IF(myPerson IN ALLSELECTED(COBRA[COBRA AM]) || myPerson IN ALLSELECTED(COBRA[Flex AM]),1,0)
Greg_Deckler I meant to ask, what is meant by an unrelated person table? Is that just joining both columns into a single table of it's own then creating the measure from that table and relating it back to my original table?
I just meant don't create a relationship between your Person table and your other table.