Forum Discussion
mmace1
Impactful Individual
Impactful IndividualBucket values, when you can't add a Calculated Column
I have a report that I've added a calculated column to, in order to bucket values. PmtSizeBracket =
SWITCH (
TRUE(),
'Payment (MC Only)'[Amount] < 100, "Under $100",
'Payment (MC Only)'[Amoun...
mmace1 , Bucketing using a measure you need an independent table, Not sure you can get that.
Please check my example bucket on measure : https://www.youtube.com/watch?v=CuczXPj0N-k
mmace1Impactful Individual
Impactful IndividualSure, thanks.
Example file in Dropbox
I tried doing a SUMMARIZECOLUMNS, but got a 'results of a query to external data sources has exceeded the maximum allowed size of 1M rows'. I had a CALCULATE/FILTER on the SUMMARIZECOLUMNS, to only get the unique values I needed (about 30k), but same message.
Ashish_Mathur
Super User
Super UserHi,
While i am certain, i can solve this with a single measure, on 1 million rows even my solution will not work.