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.
when i added into the tabular report i get some incorrect values.attached screenshot
attached screenshot with both column (banding) and measure (measure) on query 1.Measure works fine but not column :(
- MattAllington8 years ago
Community Champion
What data is in the column query1[claims-count]?
- JP19838 years ago
Helper II
claims_count is another calculated measure which count the claims...
Look at the banding measure and column in the screenshot.
- MattAllington8 years ago
Community Champion
The banding technique you have used from my website works on columns of data, not measures.
- JP19838 years ago
Helper II
why the column is showing one banding ...
any way to track what is happening in the background?
- JP19838 years ago
Helper II
using on column returns one banding not others
- MattAllington8 years ago
Community Champion
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.
- JP19838 years ago
Helper II
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] )) )
- sabizen2 years ago
Helper I
Hello Matt,
can you explain better the process of banding a measure?
Many thanks in advanceSabi