cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

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

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?

1 ACCEPTED SOLUTION
Super User

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

3 REPLIES 3
Super User

@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]) ``````
Post Prodigy

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

Super User

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