% of one total vs the other in a matrix (based on the sum of 2 calculated columns)

[asayer2]

Hello,

I have 2 columns filled with 1's and 0's these are calculated columns based on counting date ranges (required / updated).

I have a matrix where i sum these totals up (required / updated) and break them down by person/team in a matrix.  

I want a column to represent the % of one of these againest the other.

So raw data looks like:

RAW DATA	Calculated columns
name	ThingID	team	Required	Updated
Bob	1	A	1	0
Bob	2	A	1	1
Bob	3	A	1	0
Bob	4	A	1	1
Billy	5	A	1	1
Billy	6	A	1	1
Billy	7	A	1	0
Billy	8	A	1	0
Barry	9	A	1	1
Cath	10	B	1	1
Andrew	11	B	0	0
Nicola	12	B	1	1
Lauren	13	B	0	0

and i then matrix this data 2 ways:

Name	Sum of Required	Sum of Updated	% of required
Andrew	0	0	0%
Barry	1	1	100%
Billy	4	2	50%
Bob	4	2	50%
Cath	1	1	100%
Lauren	0	0	0%
Nicola	1	1	100%

OR

Name	Sum of Required	Sum of Updated	% of required
A	9	5	56%
B	2	2	100%

What i want is a way to give the '% of required' of these totals as above but i need it to be versitle being used to breakdown from differetn columns.

Many Thanks

Andy

[AllisonKennedy]

You'll have to think carefully about the different level of detail and what breakdowns you need.

How have you currently calculated the % of required? You'll need to find the right application of ALL or ALLSELECTED to get what you want.

See if this post helps:
https://www.sqlbi.com/articles/obtaining-accurate-totals-in-dax/

[asayer2]

Hello,

I need help coding the '% of required' that is my requirement here.  The two things i want to break it down with our in the dat a example above; team and employee.  

[v-easonf-msft]

Hi , @asayer2 

Please check  if this sample file help。

pbixc attached

Is this you expected result ?

If it doesn't meet you requirement,please share your expected result in excel.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.