Forum Discussion
Solved
Creating custom columns that count/sum rows from one table based on values from another
I have a list of transactions, each with a dollar amount. I'm interested in creating several metrics about various ranges of the dollar amounts for the transaction (such as 0-30 or 150-300). I m...
Hello - here is a resource that goes into detail and provides example scenarios and sample scripts. You will need to use the dynamic segmentation DAX pattern. This will allow you to avoid creating separate measures for each bin.
Hello - here is a resource that goes into detail and provides example scenarios and sample scripts. You will need to use the dynamic segmentation DAX pattern. This will allow you to avoid creating separate measures for each bin.
Thanks for the link jennratten! I haven't quite gotten it working yet (this is more of side project I'm doing), but this definitely feels like the right way forward.