cancel
Showing results for
Did you mean:
Helper I

## How to create bins for measure? urgent

I just created a new measure like this

PMT per Work=divide(sum(PMT),distinctcount(work order ID))

So now I have a list of employees' average payment.

PMT per Work

employee ID1   \$150

employee ID2    \$210

employee ID3    \$320

employee ID\$    \$130

Now I want ot created a bin so I can get this

PMT per Work bin            Count

\$100-200                               2

\$200-300                               1

\$300-400                               1

I tried to created another measure using if function. However it would give me bins. It will give me just one number for the whole data set.

Thanks you!!

8 REPLIES 8
Regular Visitor

Posting this in case it is helpful as I was looking for a similar solution to this same problem and this video explained exactly what I needed:

Dynamic Banding & Segmenting Example In Power BI Using DAX

Helper I

Did you ever figure this out?

Super User

https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/m-p/479146

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Super User

You want a measure that creates a VAR using SUMMARIZE and then do a COUNTX using that table. See this article:

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Helper I

Thank you for the answer! But I am still confused. So I should create a new table with my bins first?

Super User

You could, or you could just do a "temp table" by creating a VAR that does a SUMMARIZE. I'm actually sitting next to Michael Carlo from Power BI Tips and he sent me this link:

https://powerbi.tips/2016/04/power-bi-histogram-with-bins/

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Helper I

I follow every steps in this Link but I still can not do it. I think the problem is that the 2010 Census data in this tutorial is a column but my data is a measure.

Super User

Thinking about this, I don't see how you are going to do what you want without creating a separate table with your bins and then creating a calculated column.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors