Duplicate values using calculated measure

[SAPpowerbi]

Hello Team ,

I want to show uniqe values and multiple values diffrently using Dax Measure .

Below is table example for your ref .

Category 1	Ctegory 2
A	AB
A	AC
B	AA
C	AM
D	AA
D	BB
D	CC

Ouput needed -

Category 1	Ctegory 2	output
A	AB	2
A	AC	2
B	AA	1
C	AM	1
D	AA	3
D	BB	3
D	CC	3

Please  help me  to write a DAX - Calculated measure for above issue 

**Note - I want calculated dax as measure   (not column . )

Thank you in advance .

[v-yalanwu-msft]

Hi, @SAPpowerbi ;

If you want to  show uniqe values,may be try it.

Measure = CALCULATE(DISTINCT('Table'[Ctegory 2]),ALLEXCEPT('Table','Table'[Category 1]))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ribisht17 · Accepted solution]

Hi @SAPpowerbi 

Solution = CALCULATE(COUNT('Table'[Category2]),ALLEXCEPT('Table','Table'[Category1]))

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[SAPpowerbi]

Thank you for help , this is working.