Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to create range column..

Hi All,  Is there any way to create range column like this -10-5, -5-0, 0-5 etc automatic. I have one column which is start from -10 and highest value is 1000 i need to increments by 5 on it. Any ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

I have a question. If the value of the Main data table meets the range of multiple rows in the new table [bucket] column, how should it be counted ? Like in my screenshot ?

There are 5 values from 1 to 10 that meet the range of 0-5, so 5 is displayed, and 6 values meet the range of 5-10, so 6 is displayed, one value meets the range of 10-15, so 1 is displayed,and the rest are not satisfied, so 0 is displayed . Or is it that the two tables have unique values that correspond to each other, and then determine whether each row is satisfied ?

If the results of the above screenshots can meet your needs, you can refer to my sample.

Create a measure to count the numbers of values in Main Data table which can between the ranges . 

Measure  = CALCULATE(COUNT([Column1]),FILTER(ALL('Main data'),[Column1]<=MAX('Table'[end value])&&[Column1]>=MAX('Table'[Value])))

I have attached my pbix file ,you can refer to it .

 

Best Regards

Community Support Team _ Ailsa Tao

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous Thanks for your reply, It will help me but one more problem is that i have 5 filter column in a main data table and i don't think so this bucket will run dynamically and change the output. Isn't it?
    Because we have use x axis from the new table right.
    Please correct me if i'm wrong.