Forum Discussion
Helper IINeed help in measure
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
Memorable MemberHi 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
Srinivas3350VAR 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