Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I need a help to create a new collunm at power BI using DAX. In my example I have a colunm1 with some values that are repeat. I need a collunm that count how many times the value is repeated:
Colunm1 | How many times |
A | 3 |
A | 3 |
A | 3 |
B | 2 |
B | 2 |
C | 4 |
C | 4 |
C | 4 |
C | 4 |
D | 1 |
Anybody can help me? Thanks a lot.
Solved! Go to Solution.
New Col =
CALCULATE(
COUNTROWS( TableName),
ALLEXCEPT( TableName , TableName[Column1] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
New Col =
CALCULATE(
COUNTROWS( TableName),
ALLEXCEPT( TableName , TableName[Column1] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
U need context transition:
CALCULATE(COUNT(Table[Column1]))
This creates a filter on the value in the first column, counting the unique filtered values.
User | Count |
---|---|
53 | |
22 | |
18 | |
18 | |
13 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |