include filters in allselected function

Question

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&nbsp;need the function to return all&nbsp;the rows in a table, or all the values in a column, based on the filter selection for other calculations/measures.&nbsp;Below is the sample dataset:YearClientProject2020A12021A22022A32019B12018B22020B32021B4&nbsp;&nbsp;is it possible to get return all the rows that are matching only the selected years in slicer (respecting the filters applied).&nbsp;Thanks,AnthonyJoseph

anonymous · Accepted Answer

Hi&nbsp;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

Forum Discussion

include filters in allselected function

1 Reply

Related content

Allselected function

ALLSELECTED but include other filter

Using ALLSELECTED in Divide function

Optimize AllSelected

DATESYTD function

2020	A	1
2021	A	2
2022	A	3
2019	B	1
2018	B	2
2020	B	3
2021	B	4