sumx calculate table

Hi Anonymous 

try the following measure:

SUMX(FILTER( Ventes, Ventes[Montant HT]>20, Ventes[Date]= "2017" ), Ventes[Montant HT])

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Hi Anonymous ,

I'm sorry if my question seems to be stupid 😆, but may you confirm that the formula is written as a "New Measure" and not as "New table" ?

The SUMX returns the sum of an expression evaluated for each row in a table instead of returning a table.

Just replace it with a measure.

Best Regards,

Stephen Tao

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