Forum Discussion
Chart not filtering based on a non connected table value
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.
Super UserAnonymous , 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])))
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
Hi all,
any thoughts about it please... please...
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.