Forum Discussion

Srinivas3350's avatar
Srinivas3350
Icon for Helper II rankHelper II
3 years ago
Solved

Need help in measure

Hi I am using measure to display values in HTML content visual when I am selecting the option I am able to induvidually see the values for option i select when no option is selected i am not able to ...
  • mlsx4's avatar
    mlsx4
    3 years ago

    Hi Srinivas3350 

     

    I don't know how these measures are configured:

    VAR Equipment = [Equipment]
    VAR Supplies = [Supplies]
    VAR Spares = [Spares]

     

    But they seem to be blank if nothing is selected.

     

    Maybe you should add some other formula like:

    VAR EquipmentNS = CALCULATE([Equipment],DIM_ACCOUNTS_LEVEL[Accounts_Level_1]="Equipment"), 
    VAR SuppliesNS =CALCULATE([Supplies],DIM_ACCOUNTS_LEVEL[Accounts_Level_1]="Supplies")
    VAR SparesNS = CALCULATE([Spares],DIM_ACCOUNTS_LEVEL[Accounts_Level_1]="Spares")

     

    And use these three for the last option

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Srinivas3350 

 

Yes, but I think they are affected by a selector, isn't it? If this is the case, it won't work unless you add the three I have told you before. I mean, you need to keep yours, but include also the ones I am suggesting

Srinivas3350's avatar
Srinivas3350
Icon for Helper II rankHelper II
3 years ago

Thank you so much. I really appreciate your help this is working