Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Percentage by month line chart

Hello, I would like to know how I can show the percentage of each month, as it is in the example:

Regards,

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks your aswer helped a lot:

    divide(SUM(BASE[Cont]),CALCULATE(sum(BASE[Cont]), ALLSELECTED(BASE[dolencia ])))

3 Replies

  • Thennarasu_R's avatar
    Thennarasu_R
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    Create one Measure 

    Measure=Divide(Calculate(Sum(sales)),Calculate(Sum(sales),All(Month Column)))

    Once created Measure chnage in  Format to Percentage

    Thanks,
    Thennarasu

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi, thanks butthe measure show 0 in all months

      Dolencia % by month = Divide(Calculate(count(BASE[dolencia ])),Calculate(count(BASE[dolencia ]),All(BASE[MES])))

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks your aswer helped a lot:

        divide(SUM(BASE[Cont]),CALCULATE(sum(BASE[Cont]), ALLSELECTED(BASE[dolencia ])))