Forum Discussion
achrafkasmi
Helper I
Helper Icombining to value in one line
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 t...
Hi achrafkasmi ,
Do you mean that the result of the formula [venteporm] is incorrect or that the calculation is grouped according to the value of [venteporm].
Create measure.
Measure =
SUMX(FILTER(ALL('Table'),'Table'[Item Code]=MAX('Table'[Item Code])),[venteporm])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly