cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

## how to create range with data

Hey all,

I have a data with range from 10-100 suppose and I want segregate that data with 5 increment and count the number in that range

e.g

0-5 -0

5-10 -0

10-15 -11 like this

But I have data starting from 10 only 0-5 range is not present so when I am creating the table 0-5 range is not present

can anyone please guide me how to achieve this ?

1 ACCEPTED SOLUTION
Community Support

Hi @esam

You can refer to the following example

1.Create the calculated table

``````Table = var a=GENERATESERIES(1,100/5,1)

2.The example data table

3.Create the measure

``Measure = COUNTROWS(FILTER('Table 2',[Value]>SELECTEDVALUE('Table'[Value])*5-5&&[Value]<=SELECTEDVALUE('Table'[Value])*5))``

Best Regards!

Yolo Zhu

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

2 REPLIES 2
Community Support

Hi @esam

You can refer to the following example

1.Create the calculated table

``````Table = var a=GENERATESERIES(1,100/5,1)

2.The example data table

3.Create the measure

``Measure = COUNTROWS(FILTER('Table 2',[Value]>SELECTEDVALUE('Table'[Value])*5-5&&[Value]<=SELECTEDVALUE('Table'[Value])*5))``

Best Regards!

Yolo Zhu

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

Super User

Hello @esam

Check the attached PBIX. I have recreated the scenario.

• Create the range column.
• Create the Dim table and establish a relationship.
• Now use the range from Dim table and count measure to create a table visual. (Dont forget to turn on  "show items with no data" as below.

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors