Forum Discussion

SAPpowerbi's avatar
SAPpowerbi
Helper II
3 years ago
Solved

duplicate values count based on another column values

Hello Team ,   I want count based on business line  for category 1,Please help me to write a dax column . Please find below tabel for example. I want output based on category 1 and business Line ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, SAPpowerbi 

     

    You can try the following methods.

    Column =
CALCULATE (
    COUNT ( 'Table'[Category 1] ),
    FILTER ( 'Table', [Category 1] = EARLIER ( 'Table'[Category 1] ) )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

philouduv's avatar
philouduv
Resolver III
3 years ago

Hey there,

Try this : 

new_column = Calculate(COUNTROWS(Table),FILTER(Table,
Table[Category 1] == EARLIER(Table[Category 1])))

In red is what you have to adapt to your data model.

Best regards,