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/

tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
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/