Clustered Chart - Count Column, and % complete of each value counted

[Aimeeclaird]

Hi, apologies if this has been answered in another thread, perhaps I am not phrasing my question correctly.

I have data that looks like this (each row is a 'job'):

Region	Status	Status Key
West Midlands	Complete	1
West Midlands	Complete	1
West Midlands	Not Complete	0
East Midlands	Complete	1
East Midlands	Complete	1
East Midlands	Complete	1
North East	Not Complete	0
North East	Not Complete	0
North East	Complete	1

On a clustered chart, I want to show the Region on the Axis, and the Status as the legend. 

For each region, I want to know the total no. of Jobs in that region, and then beside it the % complete.

Can anyone help please?

[v-yingjl · Accepted solution]

Hi @Aimeeclaird ,

Based on your description, you can create these two measures:

Total = COUNTROWS('Table')
Percentage =
VAR _complete =
    CALCULATE ( COUNT ( 'Table'[Region] ), 'Table'[Status] = "Complete" )
RETURN
    _complete / [Total]

 

Attached a sample file in the below, hopes to help you.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.