Forum Discussion
Solved
Help with Measure
Dear all, Anonymous i was attempting to tweak a meaure to get some desired result as you see below, the boxes i have used to create enter values, however when i am entering the the Donut chart is...
Create another measure as follows for this kind of visuals that have multiple values for Expat/National like "Manager", "Director" and so on .... (But don't delete the current measure. You will need it for other scenarios)
FY21 Scenario Closing Projection HC Expat_National V2 = VAR __raw = [Latest HC] + [Preboarding Pipeline] + [Additional approved Exp Hire] + [Additional Approved Graduate] - [Confirmed Exists] - [Exit Pipeline] VAR SumExpatValues = [Expat_ED Value]+[Expat_M Value]+[Expat_P Value]+[Expat_S Value]+[Expat_S/A Value]+[Expat_SM Value] VAR SumNationalValues = [National_ED Value]+[National_M Value]+[National_P Value]+[National_S Value]+[National_S/A Value]+[National_SM Value] VAR X = SELECTEDVALUE ( Nationality[National/Expat_P] ) RETURN SWITCH ( SELECTEDVALUE ( Nationality[National/Expat_P] ), "Expat", SumExpatValues, "National", SumNationalValues ) + __raw
Create another measure as follows for this kind of visuals that have multiple values for Expat/National like "Manager", "Director" and so on .... (But don't delete the current measure. You will need it for other scenarios)
FY21 Scenario Closing Projection HC Expat_National V2 =
VAR __raw = [Latest HC] + [Preboarding Pipeline] + [Additional approved Exp Hire] + [Additional Approved Graduate] - [Confirmed Exists] - [Exit Pipeline]
VAR SumExpatValues = [Expat_ED Value]+[Expat_M Value]+[Expat_P Value]+[Expat_S Value]+[Expat_S/A Value]+[Expat_SM Value]
VAR SumNationalValues = [National_ED Value]+[National_M Value]+[National_P Value]+[National_S Value]+[National_S/A Value]+[National_SM Value]
VAR X =
SELECTEDVALUE ( Nationality[National/Expat_P] )
RETURN
SWITCH (
SELECTEDVALUE ( Nationality[National/Expat_P] ),
"Expat", SumExpatValues,
"National", SumNationalValues
) + __raw
