Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
prasala
Regular Visitor

Percentage of Assignment Status

‎07-10-2024 08:53 AM

Hello All, 

I have to create 2 charts with % of status. 

OrgRegionStudentAssignmentDue DateCompletion DateAssignment Status
LOMHalessandronipaulaCOV 2024:45473

45473

 

Completed On-time
LOMHalexandrevitalineCOV 2024:4547345448Completed On-time
LOMHamoahellenCOV 2024:4547345448Completed On-time
LOMHandronicajeffreyCOV 2024:4547345454Completed On-time
LOMHbagirirwajoachimCOV 2024:45491 Not Yet Due
LOMHbaptistemarieCOV 2024:4547345446Completed On-time
LOMHbaralbarshaCOV 2024:45491 Not Yet Due
LOMHberrouettedymmyCOV 2024:4547345449Completed On-time
LOMHbien-aimemartineCOV 2024:4541445464Completed Late
LOMHblairnatasha eCOV 2024:4543445453Completed Late
LOMHbylundaprilCOV 2024:4547345467Completed On-time
LOMHcarcierojulia kCOV 2024:4547345473Completed On-time
LOMHcarusonicholasCOV 2024:4547345383Completed On-time
LOMHcelestinminerveCOV 2024:4547345383Exemption
LOMHcelestinminerveCOV 2024:4547345441Completed On-time
LOMHceneusrubensCOV 2024:4547345441Completed On-time
LOMHceneusrubensCOV 2024:4547345447Completed On-time
LOMHcharlesmarieCOV 2024:4547345446Completed On-time
LOMHchrisosthommejelineCOV 2024:4547345446Completed On-time
LOMHcinea elyserose jCOV 2024:4547345443Completed On-time
LOMHclarkeandreCOV 2024:4547345449Completed On-time
LOMHcorrigankarenCOV 2024:4547345461Completed On-time
LOMHcranerebeccaCOV 2024:4547345449Completed On-time
LOMHdaymarie stephanieCOV 2024:45491 Not Yet Due
LOMHdel cid navichoqueirza yCOV 2024:4547345449Completed On-time
LOMHdel cid navichoqueirza yCOV 2024:4547345449Completed On-time
LOMHdel cidvilma aCOV 2024:4547345450Completed On-time
LOMHdel cidvilma aCOV 2024:4547345450Completed On-time
LOMHdelicatajulieCOV 2024:4542845473Completed Late
LOMHdemafelizkimCOV 2024:4547345450Completed On-time
LOMHdesirjeanCOV 2024:4547345450Completed On-time
LOMHdouyonjeanCOV 2024:45500 Not Yet Due
LOMHducasseeclideCOV 2024:45473 Past Due
LOMHedouardginaCOV 2024:45473 Past Due
LOMHedouardmarie michelineCOV 2024:4547345453Completed On-time
LOMHescobarronyCOV 2024:4547345454Completed On-time
LOMHfelicianonydia irisCOV 2024:4544945467Completed Late
LOMHfennesseyshannonCOV 2024:4547345415Completed On-time
LOMHfleurydarlyCOV 2024:4547345443Completed On-time
LOMHforbesednaCOV 2024:4547345443Completed On-time
LOMHfougereatiti floretteCOV 2024:4547345463Completed On-time
LOMHfrancoismidlyneCOV 2024:4547345454Completed On-time
LOMHfrancoismidlyneCOV 2024:4547345454Completed On-time
LOMHfrederiquefrancoiseCOV 2024:4547345442Completed On-time
LOMHgeneceelzaCOV 2024:4547345443Completed On-time
LOMHgeorgemonica ivonneCOV 2024:4547345441Completed On-time
LOMHgeorgemonica ivonneCOV 2024:4547345447Completed On-time
LOMHgerardmarleneCOV 2024:4547345463Completed On-time
LOMHgerardmarleneCOV 2024:4547345463Completed On-time
LOMHgwanyallaericCOV 2024:4547345448Completed On-time
LOMHhankathrynCOV 2024:4547345453Completed On-time
LOMHharcourtdanielCOV 2024:4547345447Completed On-time
LOMHharkinsjanineCOV 2024:4547345388Completed On-time
LOMHhyppolitepascalCOV 2024:4547345449Completed On-time
LOMHidghaddourrabiaCOV 2024:4547345463Completed On-time
LOMHisayasma cristinaCOV 2024:4547345446Completed On-time
LOMHjaroszjustineCOV 2024:4547345464Completed On-time
LOMHjean jacquesmarie lucieCOV 2024:4547345448Completed On-time
LOMHjean mary noelmarie natachaCOV 2024:4547345453Completed On-time
LOMHjean pauljocelyneCOV 2024:4547345447Completed On-time
LOMHjean philippemimoseCOV 2024:4547345443Completed On-time
LOMHjean-baptistemarie helenCOV 2024:4547345443Completed On-time
LOMHjosephjennyCOV 2024:4541445447Completed Late
LOMHjuntongdarasynthCOV 2024:4547345443Completed On-time
LOMHjuntongquincyCOV 2024:4547345434Completed On-time
LOMHkiharadamarisCOV 2024:45473 Past Due
LOMHkiharadamaris wCOV 2024:45491 Not Yet Due
LOMHkisituhenry jCOV 2024:45500 Not Yet Due
LOMHkizitogeorgeCOV 2024:4547345446Completed On-time
LOMHkizzajoyceCOV 2024:4547345457Completed On-time
LOMHkpakimasiahCOV 2024:4547345446Completed On-time
LOMHkuteesafahadCOV 2024:4547345456Completed On-time
LOMHlamiserejosette marieCOV 2024:4547345449Completed On-time
LOMHlarosastevenCOV 2024:4547345447Completed On-time
LOMHlodz numeromarieCOV 2024:4547345446Completed On-time
LOMHlopezsebastianCOV 2024:4547345453Completed On-time
LOMHlouidorlouisinaCOV 2024:4547345447Completed On-time
LOMHmarshalltracyCOV 2024:4547345426Completed On-time
LOMHmassontaraCOV 2024:45473 Past Due
LOMHmayanjafaridCOV 2024:4547345450Completed On-time
LOMHmccluskeysuzanneCOV 2024:4547345451Completed On-time
LOMHmenardmireilleCOV 2024:4547345462Completed On-time
LOMHminkoffeveCOV 2024:45473 Past Due
LOMHmukiibizabiib mariamCOV 2024:4547345449Completed On-time
LOMHnabatanzirose mukiibiCOV 2024:4547345443Completed On-time
LOMHnakiguddeannitaCOV 2024:4542845421Completed On-time
LOMHnalumansiharrietCOV 2024:4543745433Completed On-time
LOMHnampiingamaureenCOV 2024:4547345468Completed On-time
LOMHnanyombijustineCOV 2024:4547345447Completed On-time
LOMHnazairemagalieCOV 2024:4547345453Completed On-time
LOMHndimudamarisCOV 2024:45473 Past Due
LOMHoccilwilkinsCOV 2024:4547345453Completed On-time
LOMHo'keefejamesCOV 2024:4547345470Completed On-time
LOMHorificepatriciaCOV 2024:4547345464Completed On-time
LOMHpadillaria joy pCOV 2024:4550045476Completed On-time
LOMHpicardirobertCOV 2024:4547345470Completed On-time
LOMHpomponiolorraineCOV 2024:4547345395Completed On-time
LOMHprovincegamal abdelCOV 2024:4547345464Completed On-time
LOMHrobinsonjosephineCOV 2024:4547345448Completed On-time
LOMHrodriguezleoniciaCOV 2024:4547345456Completed On-time
LOMHrurengoisaacCOV 2024:45473 Past Due
LOMHruzarobrianCOV 2024:4547345463Completed On-time
LOMHruzarobrianCOV 2024:4547345463Completed On-time
LOMHsanyusylviaCOV 2024:4547345447Completed On-time
LOMHsememarie pCOV 2024:4547345446Completed On-time
LOMHsesayzainab vCOV 2024:4547345463Completed On-time
LOMHsmithhilaryCOV 2024:4547345456Completed On-time
LOMHssimbwairene millyCOV 2024:4547345455Completed On-time
LOMHstanfieldtiffanyCOV 2024:45473 Past Due
LOMHtaddeoanthonyCOV 2024:4547345434Completed On-time
LOMHtexierjude davensCOV 2024:4547345441Completed On-time
LOMHtexierjude davensCOV 2024:4547345453Completed On-time
LOMHtracyjames mCOV 2024:4547345460Completed On-time
LOMHvegamarianelaCOV 2024:45473 Past Due
LOMHvillaverdefrancis arvin dCOV 2024:4544945420Completed On-time
LOMHwalkerdanaCOV 2024:45473 Past Due
LOMHwilliamsjosephine lubowaCOV 2024:4547345473Completed On-time
LOMHyellamatyshirly marinaCOV 2024:4547345446Completed On-time
LOMHyesseniakeryCOV 2024:45473 Past Due

 

from above table I must calculate the % of Assignment Status by Org and by region
so, from above sample there are 119 total assignments.
% of Assignment Status by Org will be as below

OrgAssignment Statuscount of Assignments % of total
LOCompleted Late54.2%
Completed On-time9680.7%
Exemption10.8%
Not Yet Due65.0%
Past Due119.2%
Total 119100%

% of Assignment Status by region will be as below

RegionAssignment Statuscount of Assignments % of total
MHCompleted Late54.2%
Completed On-time9680.7%
Exemption10.8%
Not Yet Due65.0%
Past Due119.2%
Total 119100%
Labels:
Message 1 of 3
746 Views
0
2 ACCEPTED SOLUTIONS
AmiraBedh
Super User
Super User

‎07-10-2024 09:16 AM

Try creating calculated tables for both Org and Region

 

AssignmentStatusByOrg = 
SUMMARIZE(
    'YourTable',
    'YourTable'[Org],
    'YourTable'[Assignment Status],
    "count of Assignments", COUNT('YourTable'[Assignment Status]),
    "% of total", 
        DIVIDE(
            COUNT('YourTable'[Assignment Status]),
            CALCULATE(COUNT('YourTable'[Assignment Status]), ALL('YourTable'))
        ) * 100
)

 

AssignmentStatusByRegion = 
SUMMARIZE(
    'YourTable',
    'YourTable'[Region],
    'YourTable'[Assignment Status],
    "count of Assignments", COUNT('YourTable'[Assignment Status]),
    "% of total", 
        DIVIDE(
            COUNT('YourTable'[Assignment Status]),
            CALCULATE(COUNT('YourTable'[Assignment Status]), ALL('YourTable'))
        ) * 100
)

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

Message 2 of 3
716 Views
0
mickey64
Super User
Super User

‎07-10-2024 09:23 AM

Step 0: I use your DATA below.

mickey64_0-1720628457917.png

 

Step 1: I make 2 matrixs below.

mickey64_1-1720628533230.pngmickey64_2-1720628567494.png

 

mickey64_0-1720629131181.png

 

View solution in original post

Message 3 of 3
707 Views
0
2 REPLIES 2
mickey64
Super User
Super User

‎07-10-2024 09:23 AM

Step 0: I use your DATA below.

mickey64_0-1720628457917.png

 

Step 1: I make 2 matrixs below.

mickey64_1-1720628533230.pngmickey64_2-1720628567494.png

 

mickey64_0-1720629131181.png

 

Message 3 of 3
708 Views
0
AmiraBedh
Super User
Super User

‎07-10-2024 09:16 AM

Try creating calculated tables for both Org and Region

 

AssignmentStatusByOrg = 
SUMMARIZE(
    'YourTable',
    'YourTable'[Org],
    'YourTable'[Assignment Status],
    "count of Assignments", COUNT('YourTable'[Assignment Status]),
    "% of total", 
        DIVIDE(
            COUNT('YourTable'[Assignment Status]),
            CALCULATE(COUNT('YourTable'[Assignment Status]), ALL('YourTable'))
        ) * 100
)

 

AssignmentStatusByRegion = 
SUMMARIZE(
    'YourTable',
    'YourTable'[Region],
    'YourTable'[Assignment Status],
    "count of Assignments", COUNT('YourTable'[Assignment Status]),
    "% of total", 
        DIVIDE(
            COUNT('YourTable'[Assignment Status]),
            CALCULATE(COUNT('YourTable'[Assignment Status]), ALL('YourTable'))
        ) * 100
)

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Message 2 of 3
717 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All