Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX Measure

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 ...
Need Help
Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

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