DAX Measure

[Anonymous]

Hi,

I am new to Power BI.

I want to right the Dax measure to get the count of customers (ID) who succeeds after their 1 attempt. For example, for id 1 the first attempt was an error & if the second or third, etc. attempt was succeeded, then I should count as one.

ID	AttemptError	ISAttemptValid
1	error	False
2	null	True
1	null	True
3	error	false
3	null	true

Regards,

praveen

[Samarth_18]

Hi @Anonymous ,

Create a index column from Power query then create a new column like below and use it as filter on your visual:-

Column =
VAR result =
    COUNTROWS (
        FILTER (
            'Table',
            'Table'[ID] = EARLIER ( 'Table'[ID] )
                && 'Table'[ISAttemptValid] = FALSE ()
                && 'Table'[Index] < EARLIER ( 'Table'[Index] )
        )
    )
RETURN
    IF ( result > 0, 1, 0 )

Output:-

Thanks,

Samarth

[johnt75]

You could create a measure as

Num valid attempts = CALCULATE( COUNTROWS( 'Table' ), 'Table'[Is Valid Attempt] = TRUE() )