Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Groups based on Dollar Amount

Hi,   This is a follow up question to a previous question I've asked (that has already been answered).   I have an excel table 'Claim Data' I'm bringing in to Power BI.  The table has medical cla...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Amitchandak,

 

I found this link useful:  https://www.burningsuit.co.uk/blog/2018/06/dax-how-to-group-measures-into-numeric-ranges/

 

I've created my Range Table as suggested in the link above.

 

Here is a screen shot of the Table I created.  I also attached a screen shot of my relationships showing that I do not have any relations built as directed:

 

I'm now at the point where I need to create my measure(s).  I'd like to build it out so that the [Plan Payment Amount] for each [Claim Serial Number] are summed together.  This new value is what I'd like to have bucketed in to the Claim Ranges I've built in the new table.  This is because (as I stated above in the original post)...the same [Claim Serial Number] could populate multiple times.  I need each [Claim Serial Number]'s [Plan Payment Amount] to be summed together...and have this new summed value be the value that is actually being bucketed.

 

Thank you for the help so far.  I think I am close, just having trouble writing this new neasure.  Can you please help?  Please let me know if you need anymore detail from me.

 

 

Thank you,

Andrew