Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
5 years ago
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 not updating or summing it up.

 

is there a way to fix that?

here is my sample pbix

https://drive.google.com/file/d/1IlwR9wQJqQIQ0o2P5hsnouhEWS_StDdz/view?usp=sharing

 

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

     

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      5 years ago

      Anonymous 

      Worked like charm, its so helpful, i took whole day figuring this out.

      thanks so much

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      5 years ago

      Anonymous 

       

      i noticed that above measure will not work for "Card visual"

      is there anyway to fix that?