
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Value List & measure
Hi,
I would like to have 3 different calculation based on the dimension in Valuelist:
Dimension:
ValueList('A','B','C')
Measure:
=if(ValueList('A','B','C')='A', 1,
if(ValueList('A','B','C')='B',[Demand_DOS_>0<=14]
,[Demand_DOS_>14<=45]))
I am using master measures to get it clean.
Individual master measures work fine and return correct numbers.
[Demand_DOS_>0<=14] = 100
[Demand_DOS_>14<=45] = 50
I don't get this behaviour:
a) if "measure" looks like that, returns table:
=if(ValueList('A','B','C')='A', 1,
if(ValueList('A','B','C')='B',[Demand_DOS_>0<=14]
,[Demand_DOS_>14<=45]))
A =1
B=0
C=0
b) if measure looks like that, returns table:
=if(ValueList('A','B','C')='A', [Demand_DOS_>0<=14],
if(ValueList('A','B','C')='B',1
,[Demand_DOS_>14<=45]))
A = 100
B = 1
C = 0
Seems like master measure works only on first condition, if it is on another place it won't work
Can someone suggest any workaround ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=if(ValueList('A','B','C')='A', 1,
if(ValueList('A','B','C')='C',[Demand_DOS_>14<=45],
[Demand_DOS_>0<=14]
))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It returns:
A = 1
B = 0
C = 0

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you try this
=if(ValueList('A','B','C')='A', 1,
if(ValueList('A','B','C')='B',[Demand_DOS_>0<=14],
if(ValueList('A','B','C')='C',[Demand_DOS_>14<=45], 0)
))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
still returns only A = 1, B & C = 0
master measure looks like that:
