Forum Discussion

tejasruparel's avatar
tejasruparel
Frequent Visitor
6 years ago
Solved

Line chart with dynamic values

Hello, I have a function: f = a + b + c Let: a b c 0 50 100 1 51 101 2 52 102 3 53 103 4 54 104 5 55 105 6 56 106 7 57 107 8 58 108 9 59 109 ...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

tejasruparel - I cannot be certain I am following exactly what you are trying to do here. See attached PBIX below signature and see if it is at all close. If not, please explain further. I added an Index column before unpivoting and then wrote this measure:

f = 
    VAR __a = MAXX(FILTER('Unpivoted',[Attribute]="a"),[Value])
    VAR __Index = MAX('Unpivoted'[Index])
    VAR __b = MAXX(FILTER(ALL('Unpivoted'),[Attribute]="b" && [Index] = __Index),[Value])
    VAR __c = MAXX(FILTER(ALL('Unpivoted'),[Attribute]="c" && [Index] = __Index),[Value])
RETURN
    __a + __b + __c

 

tejasruparel's avatar
tejasruparel
Frequent Visitor
6 years ago

Hey Greg_Deckler , did you get a chance to look at the PBIX I attached?