Forum Discussion
summarize row counts in a new column
Create a new column called "Count" and set it equal to 1:
Count = 1
Create a new MEASURE called "Total" and set it equal to:
Total = COUNT([Count])
On report canvas, create a table visualization and add CityName and Total to it.
Community ChampionCreate a new column called "Count" and set it equal to 1:
Count = 1
Create a new MEASURE called "Total" and set it equal to:
Total = COUNT([Count])
On report canvas, create a table visualization and add CityName and Total to it.
- suji
Advocate I
Hi ,
I am new to Power BI. Need to show the total count of users, count of distinct users , and count of repeated users for the day.
I am able to get Total count and -6, distinct count -3. But i need to get the count of repeated users -2 ( Suresh and Mike)
ID Frame Date UserName
1 7/1/2016 330 PM Suresh
2 7/1/2016 330 PM John3
3 7/1/2016 337 PM Mike
4 7/1/2016 350 PM Suresh
5 7/1/2016 351 PM Mike
6 7/1/2016 358 PM Mike
MAAbdullah47Helper V
Totally Un-Clear !! How we relate it to the Field ?!
- zamboni1199
Helper II
You just solved an issue for me. Thank you!!
