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
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.
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
@dcunningham27 - Perhaps, see what you think about this Quick Measure:
You want a measure that creates a VAR using SUMMARIZE and then do a COUNTX using that table. See this article:
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:
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.
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
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!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.