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
