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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.