Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!!
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
https://www.youtube.com/watch?v=3BlTXhhbOro
Did you ever figure this out?
@Anonymous - Perhaps, see what you think about this Quick Measure:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/m-p/479146
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
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:
https://powerbi.tips/2016/04/power-bi-histogram-with-bins/
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 September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
98 | |
92 | |
38 | |
30 |