VAR Table in RETURN statement

[Medmbchr]

Hi I have created a variable in a DAX formula which returns a TABLE. However, when I try to return a value from a column in that table using SUM to sum all my columns, DAX doesn't recognize my table at all. How can I refer to a created VAR table into my RETURN statement? Thanks

[v-binbinyu-msft · Accepted solution]

Hi @Medmbchr ,

Please try below steps:

1. below is my test table

Table:

2. create measure with below dax formula

Measure =
VAR tmp =
    FILTER ( ALL ( 'Table' ), [Column2] < 50 )
RETURN
    SUMX ( tmp, [Column2] )

3. add a card visual with above measure

Pleae refer attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Medmbchr Use SUMX

[Medmbchr]

I am trying to use SUMX and STDEVX.P but nothing