Forum Discussion

mariella2's avatar
mariella2
Helper I
3 years ago
Solved

Measure to calculate current closed risks

Hi, I need help with a measure to calculate current closed risks. I have the risk table linked to the calendar[Date] table with an active relationship in Creation Date and one inactive for Mitigation...
Need Help
  • mariella2's avatar
    mariella2
    3 years ago

    Solved with the following dax: 

    = CALCULATE([Total Mitigated Risks], DATESBETWEEN('Calendar'[Date],BLANK(),MAX('Calendar'[Date])))
     
    where Total Mitigated risks = 
    CALCULATE(COUNT('Risks'[Mitigated]),'Risks'[Mitigated]="Mitigated", USERELATIONSHIP('Calendar'[Date],'Risks'[Mitigation Date]))+0
mariella2's avatar
mariella2
Helper I
3 years ago

Solved with the following dax: 

= CALCULATE([Total Mitigated Risks], DATESBETWEEN('Calendar'[Date],BLANK(),MAX('Calendar'[Date])))
 
where Total Mitigated risks = 
CALCULATE(COUNT('Risks'[Mitigated]),'Risks'[Mitigated]="Mitigated", USERELATIONSHIP('Calendar'[Date],'Risks'[Mitigation Date]))+0