Cumulative Defects Total Display in Clustered Bar and Line Chart

[Johnson_Ang]

Hi,

I have 3 measures to compute new defects found, defect rectified and Cumulative O/S defects. The codes for each individual is shown as below:

New Defects Found = 

COUNTROWS('Master Defect List PowerBI')

Defect Rectified = 

CALCULATE(

    COUNT('Master Defect List PowerBI'[STATUS]),

    'Master Defect List PowerBI'[STATUS] = "COMPLETED",

    USERELATIONSHIP('Master Defect List PowerBI'[Completion Date], 'Date'[Date])

)

Cumulative OS Defects = 

CALCULATE(

    COUNTA('Master Defect List PowerBI'[STATUS]),

    'Master Defect List PowerBI'[STATUS] IN { "IN PROGRESS" }

)

However, the figures doesn't show the total as shown below:

Appreciate the community to guide and help me on this. 

Thanks

Johnson

[amitchandak]

@Johnson_Ang , You have remove the join with created date(assumes that is used for new defect and is having active join )

Cumulative OS Defects =
CALCULATE(
COUNTA('Master Defect List PowerBI'[STATUS]),
'Master Defect List PowerBI'[STATUS] IN { "IN PROGRESS" },

crossfilter('Master Defect List PowerBI'[Created Date], 'Date'[Date]), none) )

example

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
)