Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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, 3333...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

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.