Forum Discussion
banding on measure value
- 8 years ago
The banding technique you have used from my website works on columns of data, not measures.
I don’t think you understand the issue. The banding technique explained on my website requires a table with a column of numbers. An example is a table of people and their age in the number column. Then you create a banded column next to the numeric age column. That is what the technique does. It sounds like you don’t have a column of numbers, but instead are using a measure to count records. This technique will not work for you. I suggest you creat a summary table that contains the counts you need in a column, and so the banding from there.
Hi
I did on another column instead of measure and now it returns "Operation could not be completed due to memory issue" or "reduce the number of queries"
banding = (CALCULATE(values(Bandtable[Band]),filter ( Bandtable,Query1[Claims_Count] > Bandtable[min] && Query1[Claims_Count] <=Bandtable[max] )) )