power BI exclude Duplicate Row with condition

Question

I have this table

which is a live connection from ssas to power BI I want to count duplicate based on typeName and wher completeDate is blank I wrote the folowing DAX

Duplicate = VAR Dup = COUNTROWS(FILTER('Table',EARLIER('Table'[typeName])='Table'[typeName]))
RETURN
         CALCULATE(Dup,
            FILTER('Table', 'Table'[CompletedDate]=BLANK()))

The current Output

which is wrong my desired output is to return where completeDate is blank

davidebacci · Accepted Answer · 2023-12-07 12:25:35Z

1

Variables are actually constants. Does this work?

    Duplicate = 
CALCULATE(
    COUNTROWS(
        FILTER('Table',
            EARLIER('Table'[typeName])='Table'[typeName]
            && 'Table'[CompletedDate]=BLANK()
        )
    )
)

answered Dec 7, 2023 at 12:25

davidebacci

31.5k4 gold badges20 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

power BI exclude Duplicate Row with condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related