Calculated column for calculated total
I have added 2 calculations that reflects the min value of my m1.
Now I'm struggling to get the calculated total min value in a column, so that I can use it for an additional calculation using a statement if x then x else x (C2_ First Ignition OFF) to be able to apply a visibility agent at the end.
The calculation returning 0 (C6) is following - if allcount(d1, d1:0(l(1,0,0,0,0)), m1) > 1 then sum(c2, 0(l(1,0,0)), m1) else 0 (multiple vehicle dimension members are being present). There are 5 dimensions and 2 measures.
Does anyone have a suggestion on how this could be solved?
I also need to have additional columns for my m2 using the MAX syntax.
Looking forward for your suggestions.