Need help to calculate aggregate column based on mesure value
I'm new in Power Bi and DAX world and come from Tableau.
I would like to create a column with DAX (not measure) wich give me the amount of sales for each customer/brand/year. I would like to create segmentation from this column, that's why I don't want a measure.
Here's my test model :
What i want is this (amount_customer_year) :
and if I remove "année", "product" and "brand" column, i keep the same granularity.
amount_customer_year_brand is a new attribut for my customers.