Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Bucket 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...
Need Help
mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
5 years ago
amitchandak wrote:

mmace1, Bucketing using a measure you need an independent table, Not sure you can get that.

 

 

Needing an independent table was my conclusion as well, and no - I can't, since the # of distinct values is too high to reference.  So the alternative is to bring in an entirely seperate query as a table...

And at this point I'll just write seperate measures for every bucket, and use that!

Thanks, just wanted to be sure I wasn't missing some obvious way. 


Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

One should be able to solve this with a single measure (using a disconnected table).  Share some raw data to work with.