Forum Discussion

MohannadSh1996's avatar
MohannadSh1996
Microsoft Employee
6 years ago
Solved

Using filtered values in slicer as a variable to filter other tables using DAX functions

I have many tables with Ring column. Ring R1 R2 R3 R4 I want to have a slicer for Ring to filter all the graphs without making any relationships between the tables and with supp...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi MohannadSh1996 

     

    Try this.

    FilteredValueFromTable2 = 
CALCULATE(
    SUM('Table2'[Value]),
    TREATAS( VALUES( Table1[Ring] ), Table2[Ring] )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi MohannadSh1996 ,

 

How about use VALUES() function.

Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Ring] in VALUES('Table (2)'[Ring])))

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.