Forum Discussion
Show Percentages per month
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
Super UserHi 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
My data is little different, I tried modifying the DAX but the Acual % is showing Acutal 100% for itself which is not correct.
My data looks something like this, Planned is coming from one table and Actual from other which i have connected over date table.
'll be ploting % values on weekend dates and by months Bins on Clustered column chart, or in table showing % work done that Weekend date or on the Month bin date.
Like here for example , In Sept Total Planned = 57 , Total Actual = 59 .So Total effort = (59/57)*100 = 103% work and for the month of Sept actual % = 47%. I am having difficulty preparing DAX for that.
Also for Running total, I just used the running total Quick measure for Planned , But for Actual, since it is dividing by itself by End of Sept running total is showing 100% where as it should be 47.58%