Calculate breakdown percentage of dimensions

[uko223]

Hello,

I have a straight table that shows the number of orders broken down by order sources. How can I create another measure that shows the breakdown percentage of the total by dimension. For example, if the total number of orders is  36,035 that total is 100% for the month. How can I calculate the % breakdown of that 100% by dimension in a corresponding column?

See below example. I added the 100% for illustrative purposes. 

[Prashant_Naik · Accepted solution]

Hi,

This might help you

in your second Measure expression write this and change the  number formatting in %

Count(Orders)/Count(total Orders)  

Regards,

Prashant

[Kashyap_R]

Hi 

Try this 

Count(Orders)

/

Count({1}Orders)

Hope this helps

Thanks