Percent of Column Total in a Line Chart

[Antonio_Gomez]

Hello Everyone!

My today's issue is this:

I have 2 main tables. One is for the dates and another for the values. So, I was able to make the following matrix.

Where in rows are the types of ships, in columns the years and in values the measure Cant = COUNT('RIESGOS'[ATRAQUE]).

In order to put the porcentage I selected the option "Percent of column total" as you can see in the picture below.

But, this option is not available for the Line Chart. How is the measure that I should do?

I want something like this

Where the individual values for each year add up to 100% (The axis is years, the legend type of ship and the values the percentage)

I tried this formula, but give me the percentage for the grand total:

Pct =

DIVIDE(

COUNT('RIESGOS'[ATRAQUE])

,CALCULATE(

COUNT('RIESGOS'[ATRAQUE])

,ALLSELECTED('RIESGOS')

)

)

And others similiarwith the same result

Please, I need some help!!!!

[Ramjothi]

There is a similar kind of issue discussed in below topic and please try the solution as well.

Solved: Re: Replicate "Percent of column total" in a line ... - Microsoft Power BI Community

[Antonio_Gomez]

Hello @Ramjothi ,

Thanks for participate, I saw that discussion but I didn't know how to adapt it to my case. My values are texts so I can do SUM nor MAX.

And for the other hand, I don't know what to put here "ALLEXCEPT(Sheet1,Sheet1[Date],Sheet1[Question],Sheet1[Country])"

[Antonio_Gomez · Accepted solution]

@Ramjothi I found the formula in the example 3 of the documents

https://docs.microsoft.com/es-es/dax/all-function-dax

Pct4 = DIVIDE(

COUNTX(

'RIESGOS'

,'RIESGOS'[ATRAQUE])

,CALCULATE(

COUNT('RIESGOS'[ATRAQUE])

,ALL('RIESGOS'[TipoDeBarco]))

)