Forum Discussion

MohannadSh1996's avatar
MohannadSh1996
Icon for Microsoft Employee rankMicrosoft 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


     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi MohannadSh1996 

 

Never happened to me before with any Function as it is not related, but you can format your date time column as below.

 

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn

 

MohannadSh1996's avatar
MohannadSh1996
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Mariusz, The problem was that the Table1 is missing one of the Ring values that was exist in the other table, so, all the date related to this Ring will not be shown which will cause a trimming of data. (Fixed)

amitchandak& Anonymous, thanks for your answers 😊