Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'd like to count the amount of identical values within a column and present the outcome within a new column.
Any suggestions?
Solved! Go to Solution.
Hi @fbron , you could create the next calculated column:
num = CALCULATE(COUNTROWS('Count');FILTER('Count';'Count'[item]=EARLIER('Count'[item])))
Best Regards,
Miguel
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @fbron , you could create the next calculated column:
num = CALCULATE(COUNTROWS('Count');FILTER('Count';'Count'[item]=EARLIER('Count'[item])))
Best Regards,
Miguel
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Most likely I'm doing something wrong but this doesn't work:
Any suggestions?
Hello @fbron ,
Solution suggested by @ZunzunUOC is to create DAX Column in Power BI Desktop 🙂 . Not Custom Column in Power Query editor.
Cheers,
Nawal
+91-9866755720 | Power BI Consultant
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |