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
Did you ever figure this out?
@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:
Thank you for the answer! But I am still confused. So I should create a new table with my bins first?
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.
Find out more about the March 2023 update.
In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.