Dear Community , i have a problem with a matrix i can't seem to get correct in PBI.
My matrix has 3 rows
It is possible for a project have the same project keys but different agreements. when i try to filter it out in the matrix, the matrix is not able to filter out correctly, because of the identical project key. in the example below there is two different agreements, where the agreements has the same project (KOGS). this results in the agreed estimate to show up as 213 for both agreements and projects.
But this is wrong.
in my database if i do the same filtering the results comes up like this - which is the correct result:
the calculation used for agreed estimate is:
Afreed estimate = CALCULATE(IF(HASONEVALUE(JIRA_Issues[Agreement_Name]) = FALSE(), SUMX(JIRA_Issues, [IssueAgreedEstimates]), blank()), Filter(JIRA_Issues, JIRA_Issues[Agreement_Name] <> blank()))
hope somebody can help me as i've been stuck here trying to figure out a solution for quite some time.