Forum Discussion
Cumulative Defects Total Display in Clustered Bar and Line Chart
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 =
1 Reply
- amitchandak
Super User
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-trend/ba-p/882970
)
