Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show Percentages per month

Can someone assist me with a DAX / or the correct approach if I want to show the percentages per month in a line chart?    The problem I am facing is that it divides the percentage within the whole...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Selected the Stacked area chart and the use the following measure on your values:

     

    Total total for Month-Year = 
SUM('Table'[Total]) / CALCULATE(SUM('Table'[Total]);ALL('Table'[Type]))

    If you want the measure to calculated based on a filter of type you can redo the measure to:

     

    Total total for Month-Year selected = 
SUM('Table'[Total]) / CALCULATE(SUM('Table'[Total]);ALLSELECTED('Table'[Type]))

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Selected the Stacked area chart and the use the following measure on your values:

 

Total total for Month-Year = 
SUM('Table'[Total]) / CALCULATE(SUM('Table'[Total]);ALL('Table'[Type]))

If you want the measure to calculated based on a filter of type you can redo the measure to:

 

Total total for Month-Year selected = 
SUM('Table'[Total]) / CALCULATE(SUM('Table'[Total]);ALLSELECTED('Table'[Type]))

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Appreciate it MFelix , it worked perfectly!

 

Thanks,