combining to value in one line

[achrafkasmi]

hello, 

please i have really a complicated formul on my table 

i want to combinate only "ACIMA" and "MARJANE HOLDING" at the row of [ensigne] to calculate the total of the venteprom because they have the same [item code].

this is my formula to calculate the venteprom : 

venteprom = SUMX(FILTER(ALL('V_Qtslivréegms'),
'V_QtsLivréegms'[DocDate]>=MAX('PROMI'[Datedebut])&&
'V_QtsLivréegms'[DocDate]<=MAX('PROMI'[dateFin])&&
'V_Qtslivréegms'[Item Code]=MAX('PROMI'[Item Code])&&'V_QtsLivréegms'[CardName]=MAX(PROMI[Enseigne])),'V_QtsLivréegms'[Quantity])

any help please ?

thanks,

[v-henryk-mstf · Accepted solution]

Hi @achrafkasmi ,

You can clear the impact of external filtering contexts (i.e. the filtering impact of the [enseigne] field) by creating MEASURE formulas.

Just like below:

M_ = CALCULATE(SUM('Table'[venteprom]),ALL('Table'[enseigne],'Table'[venteprom]))

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@achrafkasmi ,

,based on what I got so far

remove that column from visual or from the calculation

venteprom = SUMX(FILTER(ALL('V_Qtslivréegms'),
'V_QtsLivréegms'[DocDate]>=MAX('PROMI'[Datedebut])&&
'V_QtsLivréegms'[DocDate]<=MAX('PROMI'[dateFin])&&
'V_Qtslivréegms'[Item Code]=MAX('PROMI'[Item Code])),'V_QtsLivréegms'[Quantity])