Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Chart not filtering based on a non connected table value

Hi All,

I have 3 visuals in my report and one gets filtered based on the Year filter that i have from a unrelated table.

But the other two visuals dont get filtered based on this year filter.

Any idea how can i make them filtered without having a active connection between table1 and year table?

Anonymous
5 years ago

Anonymous

You can use in values() for unrelated tables with selectedvalue(), e.g.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

amitchandak
Super User
5 years ago
Anonymous , Assumed year is disconnected table

measure =
calculate(countrows(Table), filter(Table, Table[Year] in values(Year[Year])))

measure =
calculate(countrows(Table), filter(Table, Table[Year] in allselected(Year[Year])))

or

measure =
calculate(countrows(Table), filter(Table, Table[Year] in values(Year[Year])))

want to plot on visual
measure =
calculate(countrows(Table), filter(Table, Table[Year] = max(Year[Year])))
- Anonymous
  Not applicable
  5 years ago
  amitchandak Thanks Amit.
  But i think i need a selector kind of measure to apply it on the visual
  
  For example, if(selectedvalue( year[year])=query1[year],1,0)
  
  but not sure if this is the right way to write
  - Anonymous
    Not applicable
    5 years ago
    Hi all,
    
    any thoughts about it please... please...