topic Re: Trying to understand the outcome from my DAX code using Min & Max (especially for character) in DAX Commands and Tips

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

JustinDoh1 — Tue, 17 Aug 2021 23:16:35 GMT

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

max(Step) = 2 &&

max(Consent) is not "Refused" &&

max(ConsentDate) is not blank

Null is considered blank, correct? no?

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

amitchandak — Wed, 18 Aug 2021 07:49:20 GMT

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])

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

JustinDoh1 — Wed, 18 Aug 2021 17:10:36 GMT

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

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

amitchandak — Thu, 19 Aug 2021 05:31:34 GMT

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