Percent, Legend and Histogram

[amelief]

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 (legend).

My problem is that the total per year is not 100%. It's the sum of all my bars that is 100%.

May you help me ? 

Thanks a lot !

[Stachu · Accepted solution]

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 parts

this 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 )
    )

[v-chuncz-msft · Accepted solution]

@amelief,

You may use measure below.

Measure =
DIVIDE (
    SUM ( Table1[value] ),
    CALCULATE ( SUM ( Table1[value] ), ALLSELECTED ( Table1[answer] ) )
)

[amelief]

Thank you ! Sorry, I did'nt saw your answer before ! 

[Stachu · Accepted solution]

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 parts

this 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 )
    )

[Stachu]

what's the syntax for the [%TG...] measure?

[amelief]

I only put this params : 

Do you have an idea ?