Percentage value based on month and value wise

[Anonymous]

i have table table  name called PR details 

table  data like this 

Month     PRcom 

May          Within 

May         Winthin

May          over 

July         Within 

July         Winthin

July          over 

June         Within 

June         Winthin

June          over 

June          over 

i want to need to show count based on percantage  by month

Month        Within            over     Grand Total

May             75%            25%           100%
May            65%             35%            100%
June           50%             50%             100%

any idea .thanks in advance 

[amitchandak]

@Anonymous ,

Your current table at last is

divide(count(Table[PO]), calculate(count(Table[PO]), allexcept(Table, Table[Month])))

Can you share the expected output.

If you need June, July together , you need a new column

Month1 = if([Month] ="May", "May", "Other")

divide(count(Table[PO]), calculate(count(Table[PO]), allexcept(Table, Table[Month1])))

[Anonymous]

@amitchandak  i have attached  sample report link  . i have created many measure not work .can you please check 
  

[amitchandak · Accepted solution]

@Anonymous , looking at the data you have expected output does not seems correct.

Please check page 2