Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |