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

Hello Greg_Deckler 

 

Thanks for your response. 

Your approach is partly correct. In your approach f = [150, 153, 156 ... 180] for a = [0, 1, 2, ... 10], but I'm not sure how you are picking values for b and c. 

I want f to be [150, 151, 152 ... 160], so b = 50 and c = 100 (these values should be picked from the single value slicer)

Please see attached PBIX

 

I am essentially trying to plot f as a function of a, then be able to update f based on b and c as selected from single value slicer.

 

Thanks.