Forum Discussion
Duplicate values using calculated measure
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 .
Hi SAPpowerbi
Solution = CALCULATE(COUNT('Table'[Category2]),ALLEXCEPT('Table','Table'[Category1]))Thanks,RiteshMark 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
3 Replies
Hi SAPpowerbi
Solution = CALCULATE(COUNT('Table'[Category2]),ALLEXCEPT('Table','Table'[Category1]))Thanks,RiteshMark 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 SeriesThank you for help , this is working.
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.
