Forum Discussion
DAX Column for grouping values from same column
Hi, Need help on getting a tricky problem resolved on the data - I have the below table combining 4 columns - ID, Name, Scheme & Volume What I need to do is from the Scheme which has mul...
If you have something like
| Scheme Combination | Scheme |
| AAA-BBB | AAA |
| AAA-BBB | BBB |
| WWW-GDC | WWW |
| WWW-GDC | GDC |
with a many-to-many relationship from this table to your scheme table, then your total volume measure could be something like
Total Volume = SUMX( 'Scheme Combination Table',
SUMX( RELATEDTABLE( 'Schemes' ), 'Schemes'[Volume] )
)
That's the main problem I do not have a scheme combination 😪
That is what I am looking to create.
Are you looking to combine every scheme with every other scheme ?
What I am trying to do is work out whats the combinations of the schemes and then which accounts will fall under that combination and what volumes can I expect if I combine both those schemes together to sell to the account.
what's the logic behind a scheme combination? what determines whether a scheme combination is valid or real ?