topic Re: Need help in measure in DAX Commands and Tips

Need help in measure

Srinivas3350 — Mon, 21 Aug 2023 11:01:06 GMT

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 " & "" & FORMAT(ForecastValue, "0.00%") & "" & " of forecast with a BTS of " & "" & FORMAT(BTSValue, "#.##") & "" & " (Equipment: " & "" & FORMAT(Equipment, "£#") & "" & ")",
"Supplies", "Europe today is at " & "" & FORMAT(ForecastValue, "0.00%") & "" & " of forecast with a BTS of " & "" & FORMAT(BTSValue, "#.##") & "" & " (Supplies: " & "" & FORMAT(Supplies, "£#") & "" & ")",
"Spares", "Europe today is at " & "" & FORMAT(ForecastValue, "0.00%") & "" & " of forecast with a BTS of " & "" & FORMAT(BTSValue, "#.##") & "" & " (Spares: " & "" & FORMAT(Spares, "£#") & "" & ")",
"Europe today is at " & "" & FORMAT(ForecastValue, "0.00%") & "" & " of forecast with a BTS of " & "" & FORMAT(BTSValue, "#.##") & "" & " (Equipment: " & "" & FORMAT(Equipment, "£#") & "" & ", Supplies: " & "" & FORMAT(Supplies, "£#") & "" & " & Spares: " & "" & FORMAT(Spares, "£#") & "" & ")"
)

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

Re: Need help in measure

mlsx4 — Mon, 21 Aug 2023 11:18:00 GMT

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

Re: Need help in measure

Srinivas3350 — Mon, 21 Aug 2023 11:19:42 GMT

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

Re: Need help in measure

mlsx4 — Mon, 21 Aug 2023 11:20:45 GMT

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

Re: Need help in measure

Srinivas3350 — Mon, 21 Aug 2023 11:23:40 GMT

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