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 |
---|---|
90 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
147 | |
113 | |
95 | |
81 | |
71 |