Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a table with names that are added periodically. I would like to count the number of times each name appears in the column and display the information in a table. Each time a name is added, that name should also be added to the table. I would appreciate ideas.
This is what the column looks like and next is what the resulting table should look like
Column
Table Display
Solved! Go to Solution.
Hi @vincetaylor
Use this measure
Measure = CALCULATE(COUNTROWS('Names'), FILTER('Names', 'Names'[Name] = SELECTEDVALUE('Names'[Name])))
Regards
Phil
Proud to be a Super User!
Hi,
Drag the name column to a Table visual and write this measure
Count = countrows(Data)
Data is the name of the Table.
Hope this helps.
Hi,
Drag the name column to a Table visual and write this measure
Count = countrows(Data)
Data is the name of the Table.
Hope this helps.
Hi @vincetaylor
Use this measure
Measure = CALCULATE(COUNTROWS('Names'), FILTER('Names', 'Names'[Name] = SELECTEDVALUE('Names'[Name])))
Regards
Phil
Proud to be a Super User!
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |