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