Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Morning,
I'm trying to recreate a calulation from excel into Power bi but with no luck so far:
On a calulated column I want to count how many times a number occurs? Any help would be great.
Solved! Go to Solution.
Hi @DazzaRCIB
Please try giving the below code
Hi @Chakravarthy ,thanks for the quick reply, I'll add further.
Hi @DazzaRCIB ,
The Table data is shown below:
Use the following DAX expression to create a measure
Count = COUNTROWS('Table')
Hi @Chakravarthy ,thanks for the quick reply, I'll add further.
Hi @DazzaRCIB ,
The Table data is shown below:
Use the following DAX expression to create a measure
Count = COUNTROWS('Table')
Hi @DazzaRCIB
Please try giving the below code
This would work as a column but I need it as a measure?
User | Count |
---|---|
93 | |
85 | |
76 | |
67 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |