Forum Discussion

AnthonyJoseph's avatar
AnthonyJoseph
Resolver III
3 years ago
Solved

include filters in allselected function

Hello, I need to apply the filter (from filter pane) to the allselected function. I am aware that using values function gives the count but I  need the function to return all the rows in a table, o...
"DAX"
@Dax help
DAX ALLSELECTED
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi AnthonyJoseph,

    I'd like to suggest you use Dax expression to extract the selection and store in variable. Then you can use this as condition in formula calculations:

    formula =
VAR selection =
    VALUES ( Table2[Column2] )
RETURN
    CALCULATE (
        COUNTROWS ( ALLSELECTED ( Table1[Column] ) ),
        FILTER ( ALLSELECTED ( Table1 ), [Column2] IN selection )
    )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi AnthonyJoseph,

I'd like to suggest you use Dax expression to extract the selection and store in variable. Then you can use this as condition in formula calculations:

formula =
VAR selection =
    VALUES ( Table2[Column2] )
RETURN
    CALCULATE (
        COUNTROWS ( ALLSELECTED ( Table1[Column] ) ),
        FILTER ( ALLSELECTED ( Table1 ), [Column2] IN selection )
    )

Regards,

Xiaoxin Sheng