cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper IV

## Reporting Histogram

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
1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
Community Support

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.

Super User
Helper IV

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

COUNTROWS(RELATEDTABLE(Goal) or something else?

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors