Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
Hi @esam
You can refer to the following example
1.Create the calculated table
Table = var a=GENERATESERIES(1,100/5,1)
return ADDCOLUMNS(a,"Range",[Value]*5-5&"-"&[Value]*5)
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.
Hi @esam
You can refer to the following example
1.Create the calculated table
Table = var a=GENERATESERIES(1,100/5,1)
return ADDCOLUMNS(a,"Range",[Value]*5-5&"-"&[Value]*5)
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.
Hello @esam
Check the attached PBIX. I have recreated the scenario.
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
76 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |