Fix wrong Total in a Matrix with Count function

[Anonymous]

Dear PBI community,

I would like to pose you a problem with a measure I'm currently using. 

The problem that I want to solve is counting the number of documents that are listed as revision "0" have completed a certain phase. The problem is that from time to time I have some missing information about this step but I have some information about the following one (Revision "A") which implies that the revision "0" has been done.

I managed to take into account this problem and to have the correct result with this measure:

Actual VDA received from PBR = 
var actual=
IF (
    SELECTEDVALUE(' Vendor Documents'[Revision])="A",
        CALCULATE(
            Count('Vendor Documents'[Revision]),
            filter(' Vendor Documents',' Vendor Documents'[Revision]="A")
        ),
    CALCULATE( 
        count(Workflows[Date Completed] ) ,
        Filter ( Workflows ,
        Workflows[Step] = "PBR Review" && Workflows[Document Revision]="0" )
    )
)

return actual

 However I have a wrong total count:

I tried with SUMX and Summarize as others posts suggested, without particular success,

Do you have any idea on how I may solve this problem?

[johnt75 · Accepted solution]

Rename your existing measure as Individual Actual VDA received from PBR and then create a new measure

Actual VDA received from PBR = IF( ISINSCOPE('Table'[Document ID]), [Individual Actual VDA received from PBR],
var summaryTable =ADDCOLUMNS( SUMMARIZE( 'Table', 'Table'[Document ID]), "@val", [Individual Actual VDA received from PBR])
return SUMX( summaryTable, [@val])