Trying to understand the outcome from my DAX code using Min & Max (especially for character)

[JustinDoh1]

I am sharing my Pbix file here.

I am trying to understand the logic here:

I got the final value as 0, and I am trying to understand how I got it.

If you look at the bottom formula, basically if the second argument meets the criteria, the outcome is 0

This is data:

How do I get the 0 when:

min(Step) = 1     && 

min(Consent) is not "Refused"  &&

min(ConsentDate) is not blank

or 

max(Step) = 2     && 

max(Consent) is not "Refused"  &&

max(ConsentDate) is not blank

Null is considered blank, correct? no?

[amitchandak]

@JustinDoh1 , Try like

Refused 0817 = 
     Sumx (SUMMARIZE( Table1, Table1[Consent], Table1[ConsentDate],"_1",  
                            CALCULATE( DISTINCTCOUNT( Table1[ClientID] ),
                            ( 
                                
                                Table1[Consent] = "Refused"  &&
                                Table1[step] = 1 // && 
                                //vImmunization < vConsent
                                )               
                            ))
                            , [_1]) 

[JustinDoh1]

@amitchandak Thanks for your help. I am trying to understand the code.  What do "_1" and [_1] do?

[amitchandak · Accepted solution]

@JustinDoh1 , first one is new column I am creating in temp table, Second I am using that column