Forum Discussion

kcoffman8's avatar
kcoffman8
Regular Visitor
1 year ago
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!
DAX
powerbi
  • Aburar_123's avatar
    Aburar_123
    1 year ago

    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's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
1 year ago

Hi kcoffman8,

 

Thankyou Aburar_123 and FBergamaschi  for your reply on the issue.

If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

 

Thank you.

v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
1 year ago

Hi 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-sgandrathi's avatar
    v-sgandrathi
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi 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.