Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Power Bi Community,
Would you please help me creating a measurement that count the number of repeated record ID and returns that number in each of the rows of the same record ID.
The following is the table data
and the following is the how the result should look like:
the result above result comes from creating new column by the following formula:
where:
Solved! Go to Solution.
you can try this to create a measure
Measure = if(HASONEVALUE('Table'[Record job ID]),CALCULATE(count('Table'[Record job ID]),FILTER(all('Table'),'Table'[Record job ID]=max('Table'[Record job ID]))))
Proud to be a Super User!
you can try this to create a measure
Measure = if(HASONEVALUE('Table'[Record job ID]),CALCULATE(count('Table'[Record job ID]),FILTER(all('Table'),'Table'[Record job ID]=max('Table'[Record job ID]))))
Proud to be a Super User!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |