Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure for DOES NOT EXIST

I need to write a measure that where EpicKey doesn't not exist in another table.   Epic table (Epickey, ProjectKey) Issue table (IssueKey, EpicKey, ProjectKey)   The measure needs to give me a d...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I think I solved it with EXCEPT.

    Count of Projects = CALCULATE(
CALCULATE(
DISTINCTCOUNT(JiraEpic[ProjectKey]),
EXCEPT (
VALUES ( JiraEpic[EpicKey] ),
VALUES ( IssuesList[EpicKey] )
) -- Not in IssuesList
) +
CALCULATE(
DISTINCTCOUNT(IssuesList[ProjectKey])
)
)

     

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

Anonymous 

 

Any chance you can post sample data from both tables? (as a table if possible, to allow us to copy/paste into Excel)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I think I solved it with EXCEPT.

    Count of Projects = CALCULATE(
CALCULATE(
DISTINCTCOUNT(JiraEpic[ProjectKey]),
EXCEPT (
VALUES ( JiraEpic[EpicKey] ),
VALUES ( IssuesList[EpicKey] )
) -- Not in IssuesList
) +
CALCULATE(
DISTINCTCOUNT(IssuesList[ProjectKey])
)
)