Forum Discussion

Yaya1990's avatar
Yaya1990
Frequent Visitor
4 years ago

Filter based on Table

Hi Dears,   I am working on a dashboard reading data from 4 different sensors, and each has a different table, is there any way I can filter my data based on a table, or how can I create a filter t...
Need Help
Yaya1990's avatar
Yaya1990
Frequent Visitor
4 years ago

Yes when using, the selected value, it is showing it in the dax, but when i use switch command, i dont see any of my tables: 

 

is this becuase Create a sum of Difference measure;
(Difference_Table1,Difference_Table2,Difference_table3,Difference_table4) are calculated columns not a measure.

 

if they are columns what could be the solution? i would highly appreciate.

Yaya1990's avatar
Yaya1990
Frequent Visitor
4 years ago

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    What is a=1?
    Is 1,2,3,4 name of your columns or do have names as Table1,Table2,Table3 and Table4?

    If Difference1,Difference2.. are columns then you will need to specify an aggregation as 
    Difference=
    var a=Test['column_name']
    return
    SWITCH(TRUE(),
    a=Table1,SUM([Difference_Table1]),a=Table2,SUM([Difference_Table2]),a=Table3,SUM([Difference_Table3]),a=Table4,SUM([Difference_Table4]),[Sum_Diff])

    I hope that will solve your problem.
    Else instead of columns you can create DifferenceTable1,DifferenceTable2... as measures and not columns.

    Thanks,
    Sanket

  • Yaya1990's avatar
    Yaya1990
    Frequent Visitor
    4 years ago

    a = 1 , 1,2,3,4 is the name of my columns