Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Histogram Struggles - DAX Measure

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:

IDCheck DateHours
1241/10/202010
1241/10/202010
1241/3/202015
5481/3/20205
5481/10/20206

 

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

IDHours
12435
54811

 

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

2 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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)