Forum Discussion

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...

Frequent Visitor

4 years ago

i cannot get the first line working (var a=Test['column_name']), it is not reading the table, am i doing something wrong

Anonymous

Not applicable

4 years ago

If you have properly created the custom table using 'Enter Data' then you won't have any problem passing Table name inside the SELECTEDVALUE function.

Cross check again.

Thanks,
Sanket

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
  Frequent Visitor
  4 years ago
  - 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

Related content