Forum Discussion
Solved
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 ...
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.