Sumifs in DAX, using a value in the same row as filter condition

Hi srl01

Ok apologies for sometimes going around in circles because I am trying to understand your requirements.

What I would then do is go into the Query Editor and copy the existing table (Source Table) where you have the details. Then in this second table (Brand Group) I would then look to get the Band Scoring per Basket ID. This could possibly be done with the Group By.

After which I would then merge my first table (Source Table) with my second table (Brand Group) on the Basket ID using a left join.

What this would then do is to take the Band Total and put it across all the rows in your first table (Source Table).

And then from there you could easily create a conditional column based on the Band Score.

That would then allow you to have all your data in columns in your dataset.