Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX - Discarding Null values

I have a following table,   Network patID Status A 1 Approved A 1 Approved A   Approved A 1 Approved A 2 Declined B 3 Approved B 4 Approved B   Approved...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi Anonymous ,

     

    I think you almost had it!

     

    I just added the <> BLANK() filter to your code:

    COUNT = 
CALCULATE( 
    DISTINCTCOUNT ('TABLE'[patID]),
    FILTER ( 
        ALL('TABLE'),
        'TABLE'[Network] = EARLIER('TABLE'[Network]) && 'TABLE'[Status] = "Approved" && 'TABLE'[patID] <> BLANK()
    )
)

     

    Does this solve your issue? 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

This calculated column formula works

CALCULATE(DISTINCTCOUNT(Data[patID]),FILTER(Data,Data[Network]=EARLIER(Data[Network])&&Data[Status]="Approved"&&Data[patID]<>BLANK()))

You do not need the ALL function.