Forum Discussion
Count Duplicate Occurrences
For the first output, you just need a measure as below.
Measure = COUNTROWS(yourTable)
As to the second, you need a index column and a measure as below
Measure 2 = CALCULATE(COUNTA(yourTable[Person]),ALLEXCEPT(yourTable,yourTable[Person]))
See the attached pbix file.
Neither of those worked. I have large amounts of data in these tables, including many many columns. I want to count the occurrences that a name shows up in one column.
Measure = COUNTROWS(myTable) does not have the behavior in your screenshot. Rather, the measure makes a new column with a value of "1" in every row.
Solution two
Measure 2 = CALCULATE(COUNTA(yourTable[Person]),ALLEXCEPT(yourTable,yourTable[Person]))
Creates massive amounts of unneeded rows.
Johnathon_S wrote:
Neither of those worked. I have large amounts of data in these tables, including many many columns. I want to count the occurrences that a name shows up in one column.
Measure = COUNTROWS(myTable) does not have the behavior in your screenshot. Rather, the measure makes a new column with a value of "1" in every row.
Solution two
Measure 2 = CALCULATE(COUNTA(yourTable[Person]),ALLEXCEPT(yourTable,yourTable[Person]))
Creates massive amounts of unneeded rows.
Both shall work for the given sample in your case. While it won't apply to your real case, please post more specific sample.
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 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.
What are those "Group By" columns? You can just put them along with Measure = COUNTROWS(yourTable) to a table visual.