Display column total % and not Percent of Grand Total

[Apple08]

Hi All

I have a table of data and I am able to get the column total %, but when I use line charts to present the data across mulitple years, they showed as percentage of grand total instead.

Please could anyone help how to present the chart in column total % across mulitple financial years?

https://drive.google.com/file/d/1Bmy28Fno9O0rGj8yWC3lB2WaqQC6p62x/view?usp=sharing

Thanks.

[Apple08]

I have googled a DAX below:

% AG column total = DIVIDE (count (fact_Staff_Data[Age Group] ), CALCULATE ( count(fact_Staff_Data[Age Group]),ALLEXCEPT(dim_Dates,dim_Dates[FY] ) , ALLEXCEPT(dim_Dates,dim_Dates[FYQtr])),0)

However the result was showing the sum of rows to 100% rather than the column total 100%.

Any help would be appreciated.

[Apple08]

I need a DAX measure to get the column percentage like the below then to plot a graph:

[aj1973 · Accepted solution]

@Apple08 

Here you go

Measure =
DIVIDE (
'_AG Measures'[YTD Age Group],
CALCULATE (
'_AG Measures'[YTD Age Group],
ALLSELECTED ( 'fact_Staff_Data'[Age Group] )
)
)

[Apple08]

Millions of thanks!  I appreciated it very very much 🙂

[Apple08]

Do I need to setup some measures for the line chart or is it possible to switch to column chart?

[aj1973]

Didn't understand your question, sorry.

like this?

[Apple08]

Hi Amine

The question I asked was before you sent out your DAX, this is all resolved now.  Many thanks again for your help. 🙂

[aj1973]

Hi @Apple08 

In the line chart you don't have this option

You only have the Percent of grand total option