Forum Discussion

Johnathon_S's avatar
Johnathon_S
Regular Visitor
8 years ago

Count Duplicate Occurrences

I have been through tons of this forum searching for the answer to this. It seems like a common question, but I am unable to generate the field that I'd like. In the PowerBI query editor, or in the R...
Need Help
Tutorial Requests
Johnathon_S's avatar
Johnathon_S
Regular Visitor
8 years ago

Here is a more specific example. Sensitive information has been redacted. 

 

 

As you can see there is quite a lot of data. Many of the fields have been minimized.

 

A solution I have done was duplicating the query table and using "Group By" in the query editor. However, I want to have that information in just one table if at all possible. 

 

 

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago
Johnathon_S wrote:

Here is a more specific example. Sensitive information has been redacted. 

 

 

As you can see there is quite a lot of data. Many of the fields have been minimized.

 

A solution I have done was duplicating the query table and using "Group By" in the query editor. However, I want to have that information in just one table if at all possible. 

 

 

Johnathon_S

What are those "Group By" columns? You can just put them along with Measure = COUNTROWS(yourTable) to a table visual.