Forum Discussion
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...
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
a = 1 , 1,2,3,4 is the name of my columns