topic Re: Possible Bucketing in DAX Commands and Tips

Possible Bucketing

Kebas_Leech — Mon, 25 Sep 2023 13:07:48 GMT

Hello everyone,

I have a simple measure that calculates the % of losses that I have: [% losses] = Divide ( loss, allquantity)

What I'm trying to figure out is a way to filter that measure, [%losses], given certain criteria.

Example: which is the total [%losses] when considering values that are less than 5%, 10% and so on, like its shows in the following graph:

I thought this was a case of dynamic sgmentation/bucketing but i cant seem to make it work.

Any ideas?

Thanks

lbendlin — Tue, 26 Sep 2023 16:23:02 GMT

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Anonymous — Wed, 27 Sep 2023 09:07:51 GMT

I suggest you to create a Percentage table to help your calculation.

Percentage = GENERATESERIES(0,1,0.05)

Measure:

Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER('Table',[% losses]<=MAX(Percentage[Percentage])))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kebas_Leech — Thu, 28 Sep 2023 09:25:14 GMT

Hello Anonymous

First of all, I want to personally thank you for using your time to help me.

It worked, I made some adjustments but overall, what was missing was the generateseries.

Thanks again.

Kindly