Possible Bucketing

[Kebas_Leech]

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

[v-rzhou-msft · Accepted solution]

Hi @Kebas_Leech ,

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]

Hello @v-rzhou-msft 

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

[lbendlin]

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-...
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/1447...