Dax to calculate all subjects by completed subjects

[ClaireBear]

Hi, 

I am trying to work out the Training Status % based off all subjects vs completed subjects. 

For one customer, the total subjects to be completed are 4 (account id 1) and another 49 (account id 2) for example

My calculations are:

Total Subjects = DISTINCTCOUNT('Dimension Subject'[SubjectID])

Completed Subjects = CALCULATE(Distinctcount('DimensionLearning'[SubjectID]),'DimensionLearning'[issubjectcompleted]=True)

Training Status % = [Completed Subjects]/[Total Subjects]

Below is an example for Account ID 1. Would you be able to assist with a dax to fix table 1 and get a result of table 2?

The issue is with the Subjects All calculation

Table 1			Incorrect		Incorrect
Client	Account id	Zone	Subjects All	Completed Subjects	Training Status %
CLA	1	Pizza	3	3	100%
CLA	1	Cake King	3	3	100%
CLA	1	Fish	3	1	33%
CLA	1	Milk Shake	2	1	50%
CLA	1	Coffee	4	3	75%
CLA	1	Pies	3	2	67%
CLA	1	Burgers	3	2	67%

Table 2			Correct		Correct
Client	Account id	Zone	Subjects All	Completed Subjects	Training Status %
CLA	1	Pizza	4	3	75%
CLA	1	Cake King	4	3	75%
CLA	1	Fish	4	1	25%
CLA	1	Milk Shake	4	1	25%
CLA	1	Coffee	4	3	75%
CLA	1	Pies	4	2	50%
CLA	1	Burgers	4	2	50%

Thanks

[ClaireBear · Accepted solution]

Hi, thank you so much. I managed to add a calculated column

No of Subjects= CALCULATE(DISTINCTCOUNT('Dimension Subject'[SubjectID]),FILTER('Dimension Subject','Dimension Subject'[accountID]=EARLIER('Dimension Subject'[accountID])))

I then created a measure using the max function and it seemed to work.

Total Subjects= max('Dimension Subject'[No of Subjects])

[SteveHailey]

Hi @ClaireBear. Try this for your total subjects measure:

Total Subjects =
CALCULATE (
    DISTINCTCOUNT ( 'Dimension Subject'[SubjectID] ),
    ALL ( 'Dimension Subject' )
)