Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Month wise percentage calculator by text value

i have table name called PO compliance 

 

Thats table have three column 

 

Month               PO         

May                Within 

May                Within 

May                 oVer 

May                Within 

June               Within 

June                Within 

June                 oVer 

June                Within 

July                 Within 

July                 Within 

July                oVer 

July               Within 

 


May together should be 100

Not may jun july together 100, 
Not may jun july together 100
 
table look like 
 
                    Within           Over            Total 
May              75%              25%           100%
 
June               75%             25%           100%
 
July                 75%            25%          100%
 
 
i tired many measure but not working any idea.thanks in advance 
3 REPLIES 3
Anonymous
Not applicable

@amitchandak  i have month wise count  PO   values. now i have only three months may,june,july.  i want percentatge month wise not a over all ..

May together should be 100  
Not may jun july together 100
 
please find the screen shot  for reference 
 
THENNA_41_0-1630555308030.png

 

@Anonymous , check page 2

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
amitchandak
Super User
Super User

@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])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.