COUNTIF case in A but not in B

[setis]

Hi all,

I hope that you can help me with this. 

I have 3 tables with the following relationships:

[Fees]*--->1[Cases]1<---*[Financial] 

I would like to have a measure to calculate the number of cases that are in [Fees] but not in [Financial]

I have a card with the following measure:

NrCasesFee&NOPayment = CALCULATE (
            DISTINCTCOUNT(Fees[CaseID]);
            FILTER (
                ALL (Fees[CaseID]);
                CALCULATE(SUM(Financial[Amount Paid]))=0
            )
)

My issue is that when I select a case in the table [Fees] and the case is not in [Financial], the measure works (showing "1")

However, when nothing is selected, instead of showing the Nr of cases in [Fees] that are not in [Financial], it shows "Blank"

What am I doing wrong?

Thanks in advance!

[AlB · Accepted solution]

@setis 

I see

You have to modify the filtering in the CALCULATETABLE then. Right now we are just filtering for amount > 0 and that is why the row > 0 is taken into account. You want SUM(amount) > 0 as we do working out the second listing.

NrCasesPayment&NOFee =
COUNTROWS (
    EXCEPT (
        FILTER (
            DISTINCT ( Financial[CaseID] );
            CALCULATE ( SUM ( Financial[Amount Paid] ) ) > 0
        );
        FILTER (
            DISTINCT ( Cases[CaseID] );
            CALCULATE ( SUM ( Fees[Amount Paid] ) ) > 0
        )
    )
)

which if I'm not mistaken should be equivalent to this with your set-up:

NrCasesPayment&NOFee =
COUNTROWS (
    EXCEPT (
        FILTER (
            DISTINCT ( Cases[CaseID] );
            CALCULATE ( SUM ( Financial[Amount Paid] ) ) > 0
        );
        FILTER (
            DISTINCT ( Cases[CaseID] );
            CALCULATE ( SUM ( Fees[Amount Paid] ) ) > 0
        )
    )
)

 and to this:

NrCasesPayment&NOFee =
COUNTROWS (
    EXCEPT (
        FILTER (
            DISTINCT ( Financial[CaseID] );
            CALCULATE ( SUM ( Financial[Amount Paid] ) ) > 0
        );
        FILTER (
            DISTINCT ( Fees[CaseID] );
            CALCULATE ( SUM ( Fees[Amount Paid] ) ) > 0
        )
    )
)