Forum Discussion

amelief's avatar
amelief
Frequent Visitor
7 years ago
Solved

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 ...
  • Stachu's avatar
    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 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's avatar
    7 years ago

    amelief,

     

    You may use measure below.

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