Chart not filtering based on a non connected table value

[Anonymous]

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?

[amitchandak]

@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]

@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]

Hi all,

any thoughts about it please... please...

[V-pazhen-msft · Accepted solution]

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