Summarising a new table in categories

[Anonymous]

I have been looking to summarise to following data points % into categories and count how many is in each category. for example

Data

Type	%
A	25%
B	9%
C	80%
D	85%
E	32%
F	50%
G	65%

With result of something like this

Range	Count
Range 0-9%	1
Range 10-19%	0
Range 20-29%	1
Range 30-39%	1
Range 40-49%	1
Range 50-59%	1
Range 60-69%	1
Range 70-79%	0
Range 80-89%	2
Range 90 - 100%	0

[Whitewater100]

Hi MDJ:

Check this out and see if it suits your needs. Thanks!https://drive.google.com/file/d/1-rZ0QFcSUULflXwHcKtYbhGk-IEfexwf/view?usp=sharing 

[tackytechtom · Accepted solution]

Hi @Anonymous ,

How about this 🙂 

To get there, I calculated a calculated category column:

TomsCategories = 
SWITCH (
    TRUE(), 
    Table13[%] <= 0.09, "Range 0-9%",
    Table13[%] <= 0.19, "Range 10-19%",
    Table13[%] <= 0.29, "Range 20-29%",
    Table13[%] <= 0.39, "Range 30-39%",
    Table13[%] <= 0.49, "Range 40-49%",
    Table13[%] <= 0.59, "Range 50-59%",
    Table13[%] <= 0.69, "Range 60-69%",
    Table13[%] <= 0.79, "Range 70-79%",
    Table13[%] <= 0.89, "Range 80-89%"
    , "Range 90-100%"
)

Otherwise, if you are planning to do a histogram and you'd like to create some buckets, I can recommend this documentation:

Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs

Does this fix your issue?

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom