Forum Discussion
Solved
Many to One Relationship Summarizing and Counting
Table 1 and Table 2 have a relationship by account ID, ideally I would like a Matrix as seen in the 3rd table. Thank you!
Hi kcoffman8 ,
you can change that measure to Calculated column as below if in case you want to use that calculated bracket as a Column in Matrix visual.
Calculated Bracket =var total_value = SUMX(FILTER('Table A','Table A'[Account Id]=EARLIER('Table A'[Account Id])),'Table A'[Value])return SWITCH(TRUE(),total_value<=5000,"5k or Less",total_value>5000 && total_value<=10000,"5k - 10K",total_value>10000 && total_value<=15000,"10k - 15K")FYI... below is the base table structure that i am using,
v-sgandrathi
Community Support
Community SupportHi kcoffman8,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
Thank you.
v-sgandrathiCommunity Support
Community SupportHi kcoffman8,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
Thank you.