topic Re: How to calculate percentage column in DAX Commands and Tips

How to calculate percentage column

Anonymous — Sun, 23 Oct 2022 01:09:41 GMT

Dear all,

How to calculate percentage column, for below image:

And this is the measure used to calculate the table above:

Count LStatus = COUNT(Table2[Latest Status])

Thanks in advance for your help and assistance.
Prima Indonesia

Shaurya — Sun, 23 Oct 2022 04:40:57 GMT

Hi Anonymous,

You can use:

% = [Count LStatus] / CALCULATE([Count LStatus],ALL('Table'))

Then format the measure as percentage.

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog:

Anonymous — Sun, 23 Oct 2022 06:25:32 GMT

Dear Shaurya,

Cool ! It works !
Thank you so much, problem solved.

Again, thank you.
Prima Indonesia