How to conditionally assign new values to Aggregated values

[rax99]

Matrix below shows day number as columns, and customers by row. The values are simply a count of the calls.

I

I need the values to show either a 1 or a 0 depending on if there are values in that cell. so when Count(NID) is blank, then 0 ELSE 1. 

Then the totals at the bottom of the matrix should sum up the 1s down the column,

Any ideas?

[Zubair_Muhammad]

@rax99

Give this MEASURE a shot

Measure=
IF (
    HASONEFILTER ( table1[Customer] ),
    IF ( COUNT ( Table1[NID] ) > 0, 1 ),
    SUMX (
        VALUES ( table1[Customer] ),
        CALCULATE ( IF ( COUNT ( Table1[NID] ) > 0, 1 ) )
    )
)

[rax99]

Brilliant That worked! Any idea how to populate the rest of the matrix with 0s where there is no value?

[Zubair_Muhammad · Accepted solution]

hi @rax99

Try this

Measure =
IF (
    HASONEFILTER ( table1[Customer] ),
    IF ( COUNT ( Table1[NID] ) > 0, 1, 0 ),
    SUMX (
        VALUES ( table1[Customer] ),
        CALCULATE ( IF ( COUNT ( Table1[NID] ) > 0, 1, 0 ) )
    )
)