Reporting Histogram

[PrivateAnalytic]

Hello all! I have data which looks likes it is below. I am looking to create a sort of Histogram which shows the amount of Goals a Person has. So Person 22222222 would be in a 5, 1111111 in a 3, 33333 in a 2, and 55555 in a 1 sort of bucket. I was wondering how I would be able to like bucket these things into a measure or calculation or some sort so that I can create a histogram?

PersonID	Goal
22222222	Savings
22222222	Debt
22222222	Timeline
22222222	Search
1111111	Savings
1111111	Search
1111111	Timeline
33333	Savings
33333	Debt
55555	Search

[v-rongtiep-msft · Accepted solution]

Hi @PrivateAnalytic ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure = CALCULATE(COUNT('Table'[PersonID]),FILTER(ALL('Table'),'Table'[PersonID]=SELECTEDVALUE('Table'[PersonID])))

If I hvae misunderstood your meaning, please provide pbix file (or some sample data ) without privacy information and desired output with more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PrivateAnalytic , You can check some Histogram visual

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=Histogram&pag...

Or bar visual with countrows(Table) measure

[PrivateAnalytic]

If I were to use the COUNTROWS function, would I use the

COUNTROWS(RELATEDTABLE(Goal) or something else?