Forum Discussion
Ignoring Relationships using CALCULATE
Data model is following: 1. Table JIRA_ISSUE - contains all JIRA items; 2. Table JIRA_SPRINT_CALENDAR - contains Sprint data (Start and Release dates) 3. Between these 2 tables, there is created R...
Issue was resolved by changing Data Model.
Hi Anonymous ,
Please try this measure:
EVALUATE
CALCULATE (
COUNTROWS ( JIRA_ISSUE ),
ALL ( JIRA_ISSUE ),
JIRA_ISSUE[Issue Type] = "Story",
JIRA_ISSUE[Status] <> "Story: Not Required",
NOT ISBLANK ( JIRA_ISSUE[Sprint VersionID] ),
ALLEXCEPT (
JIRA_SPRINT_CALENDAR,
YEAR ( JIRA_SPRINT_CALENDAR[Release Date] ),
MONTH ( JIRA_SPRINT_CALENDAR[Release Date] )
)
)
For more advice, please post sample data of JIRA_ISSUE and JIRA_SPRINT_CALENDAR, and show us your expected result. How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Issue was resolved by changing Data Model.