Cannot figure out how to use ALL in this measure

[ansa_naz]

Hi all

If someone can help with below would relaly appreciate it:

I have tables as follows:

Matrix:

Job     Name

100     MatrixA

101     MatrixB

102     MatrixC

103     MatrixD

Jobs

Job     Type     Fault    ProjID

100     T01       F01     P01

101      T02      F01     P02

102     T03        F05    P03

103     T03         F02   P04

104     T11         F12   P05

Projects

ProjID      Job       Controller

P01          100      C01

P02           101     C03

P03           102      C01

P04            103     C02

P05            104     C04

Revenue

ProjID      Amount       Invoice

P01          50.00           I01

P01          62.00           I02

P01         12.00            I02

P02         25.50           I03

P02         5.00             I04

P02          6.00            I05

P02         10.00           I05

P03         125.00          I06

P05         55.00           I07

Invoices

Invoice      Amount         Unpaid  

I01            50.00              0.00     

I02            74.00              15.00 

I03            25.50              5.00   

I04           5.00                0.00

I05           16.00               2.50

I06           125.00             0.00

I07            55.00             0.00

I want to show all Unpaid invoice amounts for each Matrix project:

Matrix[Job]         Matrix[MatrixName]    Invoices[Unpaid]

100                     MatrixA                        15.00

101                     MatrixB                         7.50

102                     MatrixC                         0.00

103                     MatrixD                         0.00

However I am currently getting a blank in Matrix[Job] 103 for Outstanding:

Matrix[Job]         Matrix[MatrixName]    Invoices[Unpaid]

100                     MatrixA                        15.00

101                     MatrixB                         7.50

102                     MatrixC                         0.00

103                     MatrixD                        

Any way to use the ALLEXCEPT filter to make sure I get the correct table returned?

Cheers for all help

[jmalone]

From what I can tell, Job 103 (MatrixD) has a ProjectID = P04. However, the 'Revenue' table does not have any records for project P04. Since the Revenue table is needed to build a relationship between Matrix[Job] and Invoice[Unpaid], nothing is being returned. 

This is how it seems the model is set up. Notice the Revenue table is bridging the gap between ProjID and Invoice.

[ansa_naz]

Any way to return a zero if the entry would be blank otherwise?