Need help in measure

[Srinivas3350]

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 see any the data for feild below

i used all the 3 different measures in the variables to display those figures when i am not selecting any option i need to see those values there individually and the measure i used is 

DynamicMessage_v1 =
VAR SelectedOption = SELECTEDVALUE(DIM_ACCOUNTS_LEVEL[Accounts_Level_1])
VAR ForecastValue = [BTS(GBP-Forecast)%]
VAR BTSValue = [BTS(GBP-Forecast)]
VAR RedStyle = "style='color: red;'"
VAR BoldStyle = "style='font-weight: bold;'"
VAR Equipment = [Equipment]
VAR Supplies = [Supplies]
VAR Spares = [Spares]

RETURN
SWITCH(
SelectedOption,
"Equipment", "Europe today is at <span " & RedStyle & ">" & "<span " & BoldStyle & ">" & FORMAT(ForecastValue, "0.00%") & "</span>" & "</span> of forecast with a BTS of <span " & RedStyle & ">" & "<span " & BoldStyle & ">" & FORMAT(BTSValue, "#.##") & "</span>" & "</span> (Equipment: " & "<span " & BoldStyle & ">" & FORMAT(Equipment, "£#") & "</span>" & ")",
"Supplies", "Europe today is at <span " & RedStyle & ">" & "<span " & BoldStyle & ">" & FORMAT(ForecastValue, "0.00%") & "</span>" & "</span> of forecast with a BTS of <span " & RedStyle & ">" & "<span " & BoldStyle & ">" & FORMAT(BTSValue, "#.##") & "</span>" & "</span> (Supplies: " & "<span " & BoldStyle & ">" & FORMAT(Supplies, "£#") & "</span>" & ")",
"Spares", "Europe today is at <span " & RedStyle & ">" & "<span " & BoldStyle & ">" & FORMAT(ForecastValue, "0.00%") & "</span>" & "</span> of forecast with a BTS of <span " & RedStyle & ">" & "<span " & BoldStyle & ">" & FORMAT(BTSValue, "#.##") & "</span>" & "</span> (Spares: " & "<span " & BoldStyle & ">" & FORMAT(Spares, "£#") & "</span>" & ")",
"Europe today is at <span " & RedStyle & ">" & "<span " & BoldStyle & ">" & FORMAT(ForecastValue, "0.00%") & "</span>" & "</span> of forecast with a BTS of <span " & RedStyle & ">" & "<span " & BoldStyle & ">" & FORMAT(BTSValue, "#.##") & "</span>" & "</span> (Equipment: " & "<span " & BoldStyle & ">" & FORMAT(Equipment, "£#") & "</span>" & ", Supplies: " & "<span " & BoldStyle & ">" & FORMAT(Supplies, "£#") & "</span>" & " & Spares: " & "<span " & BoldStyle & ">" & FORMAT(Spares, "£#") & "</span>" & ")"
)

can anyone help me this is very urgrnt for me Thank you in adavnce

[mlsx4 · Accepted solution]

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

[Srinivas3350]

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

this 3 are measure which we are seeing data for Equipment , Spares & Supplies

as i can see the data when i select those options as i attached screenshot above

[mlsx4]

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]

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