Forum Discussion
amelief
7 years agoFrequent Visitor
Percent, Legend and Histogram
Hi Everyone, I'm trying to make a histogram with a year-by-year comparison of answers 1 to 5. it gives me this : My question is about the total : I don't kown how to have 100% by year ...
- 7 years ago
I don;t think it;s possible with just UI, you will need to:
1) create a new measure (press 'New Measure' in Modelling in the ribbon)
2) syntax should be something like this - you will need to adjust the blue partsthis code assumes that Annee is a numeric field, not text
% of total = VAR varYear = MAX ( Table[Annee] ) RETURN DIVIDE ( SUM ( Table[Nombre de Quel...] ), CALCULATE ( SUM ( Table[Nombre de Quel...] ), Table[Annee] = varYear ) ) - 7 years ago
You may use measure below.
Measure = DIVIDE ( SUM ( Table1[value] ), CALCULATE ( SUM ( Table1[value] ), ALLSELECTED ( Table1[answer] ) ) )