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?
Solved! Go to 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.
@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])))
@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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
124 | |
76 | |
69 | |
54 | |
53 |
User | Count |
---|---|
191 | |
104 | |
83 | |
79 | |
78 |