Histogram Struggles - DAX Measure

[Anonymous]

Dear Power BI Community,

I have a measure that calculates the total of something and I have not found out a way to not use a measure. Is there a way to create bins for a measure?

My table is set up like this from a report:

ID	Check Date	Hours
124	1/10/2020	10
124	1/10/2020	10
124	1/3/2020	15
548	1/3/2020	5
548	1/10/2020	6

I do have a measure that gets me the following table:

ID	Hours
124	35
548	11

My end goal is to be able to make a histogram with a unique count of ID as the value and hours (bins) as the x-axis. So I need to make sure total hours is a calculated column.

Any help on this would be appreciated

[harshnathani]

Hi @Anonymous ,

You can have a look at this video for custom bins and creating histograms.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Mariusz]

Hi @Anonymous 

On the attached, you will find a file with a solution.

Essentially you can just create a relationship between your summarized table and Original table and later use Bins table to slice end dice.

The attache has two versions of bins table Power Query and DAX that you already have.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.