Forum Discussion

Ritesh_Air's avatar
Ritesh_Air
Icon for Post Patron rankPost Patron
6 years ago

SumX con total

Hola Estoy tratando de encontrar clientes que compraron más de $500 en cosas. SumX for More than $500 with summarize = SUMX ( 'CPP POS', CALCULATE ( SUM ( 'CPP POS'[Sales...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

@Ritesh_Air , Probar como

ventas á sumx(filter(SUMMARIZE ( RETAILER, RETAILER[Parent Retailer AB Number] ,"_1" ,SUM ( 'CPP POS'[Sales Amount] ) ),[_1]>500),[_1])


Recuento de minoristas: countx(filter(SUMMARIZE( RETAILER, RETAILER[Parent Retailer AB Number] ,"_1" ,SUM ( 'CPP POS'[Sales Amount] ) ),[_1]>500),[Parent Retailer AB Number])