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.

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

      Sure, 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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        Hi,

        While i am certain, i can solve this with a single measure, on 1 million rows even my solution will not work.