Filter and sum data according to conditions power query

Hey

I group the data in my data table according to the first 4 columns and I got the sum for the columns "No_P" and "NoSold_P".

Regarding the additional column "Amount_Spent", I want to sum it in two different ways, so I added a new column "Amnt", then selected all the rows and got the data in the table

I want to sum the data of "Amount_Spent" once in a new column according to all the rows in the table
and a second to sum the data only on the condition that the "No_P" field in the table is not empty or greater than zero.

Additionally I would like to count how many occurrences for each table in "Amnt" has a null or zero value

Would appreciate help
I tried for several hours to solve it myself without success...

Originally Posted by rorya

For the total, add a new column using:
=List.Sum([Amnt][Amount_Spent])

For the restricted total, something like:
=List.Sum(Table.SelectRows([Amnt], each [No_P]>0)[Amount_Spent])

and for the count:
=Table.RowCount(Table.SelectRows([Amnt],each [No_P] = 0 or [No_P] = null))

Thank you

How can i do the same using Filter?

Originally Posted by rorya

I don't understand what you mean. Table.SelectRows is the M code for the filtering you do in the PQ editor.

Can i use DAx function in power qweary?

Somthung like

Filter 1st example = FILTER(
DimProduct,
DimProduct[Color]='Red')