Need help!

[Anonymous]

Hello guys,

I want to create a column that counts the combinations of x and the relevant variable from column B. I know there is another way around but I'm interested in finding a way to do it with Dax.

Thanks.

A	B	???
x	a	3
x	b	2
y	b
y	a
x	c	1
z	c
x	a	3
x	a	3
x	b	2

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can also try below codes

column = 
COUNTROWS (
    FILTER (
        'Table (3)',
        [A] = "x"
            && [A] = EARLIER ( 'Table (3)'[A] )
            && [B] = EARLIER ( 'Table (3)'[B] )
    )
)

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Anonymous]

Hello everyone,

This formula provided by @amitchandak works fine!

??? = if([A] ="X", countx(filter(Table, [A] =earlier([A]) && [B] =earlier([B])),[A]), blank())

[Jihwan_Kim]

Hi, @Anonymous 

Please try the below DAX Measure.

counting = COALESCE(

          CALCULATE( COUNTROWS (

                                   FILTER( 'Table', 'Table'[A] = "x"))),

                    "")

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

[Anonymous]

Good morning @Jihwan_Kim 

Can't get this to work, I'm not sure why.