Forum Discussion
rpinxt
Solution Sage
Solution SageLegend problem with line and stacked column chart
Ok this is the situation in a picture: The columns are relates to volumes. And the categories (from the legend) correspond to the volumes. The line however is based on FTE and the category...
How about use measures?
Affiliate = SUMX(FILTER('Table name','Table name'[category]="Affiliate"),'Table name'[volume])
Direct = SUMX(FILTER('Table name','Table name'[category]="Direct"),'Table name'[volume])
Distributor = SUMX(...
rpinxtSolution Sage
Solution SageYou are correct.
Will look into this.
Somehow my SUMX is not returning data....
Affiliate_units = SUMX(FILTER('AVN Excel Data','AVN Excel Data'[Category]="Affiliate"),[Units])
So maybe if I get this fixed I can solve it like this.
mickey64
Super User
Super UserHow about this formula below?
Affiliate_units = SUMX(FILTER('AVN Excel Data','AVN Excel Data'[Category]="Affiliate"),'AVN Excel Data'[Units])