Issues using FILTER in combination with SUM

[Anonymous]

I am trying to make a custom measure. What I want is to:

1. Filter out some rows from an existing table.
2. Then from the filtered table select a certain column.
3. Then square all values in the column.
4. Then sum all values in the column.

I thought I could use a FILTER to do this but that won't work. I am getting an error telling me the syntax for the SUM function is incorrect (have not even squared the number yet).

SUM(FILTER(MyTable, MyTable[class] = "1")[columnToSelect])

[HashamNiaz]

Hi @Anonymous !

You can use following DAX coede;

Class = CALCULATE(SUM(Table[Column]), FILTER(Table, Table[Class] = "1"))

Table is your table name & column is your column you want to sum.

Regards,

Hasham

[Anonymous]

How would one square all values before summing them?

[HashamNiaz · Accepted solution]

Hi @Anonymous !

Create a new column using following DAX to have Sqr. values of your column;

SqrtColumn = SQRT(Table[Column])

Now you can use this new column in your DAX measure formula;

Class = CALCULATE(SUM(Table[SqrtColumn]), FILTER(Table, Table[Class] = "1"))

Regards,

Hasham