Forum Discussion
Helper IFiltered count isn't reflected in other visuals when selected
I have a simple measure
m1: Calculate(FactTable, [solved]=true())
m2 Calculate(FactTable, [solved]=false())
In the same table I have a column (teacher) which is also either true or false. If you have 1-6 where Solved is true, the first and last 3 have true in teacher.
If I put both measures on a piechart it works fine.
If I click the true part in the pie chart for teacher, the pie chart for Solved changes fine.
However if click on the true part of the solved pie chart, the teacher pie chart won't change to reflect this filter.
I have tried countax(filter(factTable, solved=true(),true);
as well, I have tried with allselected,values and all, but I can't get this filter function to work.
Any ideas or solutions?
Alright, a little update.
I made it work.
All I had to do was put the [solved] column into the "Legend" part of the visual.
The only problem this gives is that I couldn't give the legend the name I wanted (solved, not solved) but was instead shown as "true" or "false". Changing the data labels so I showed percentage and category name was a solution though.
3 Replies
AndersMadsento the top
v-yuta-msftCommunity Support
Hi AndersMadsen,
"However if click on the true part of the solved pie chart, the teacher pie chart won't change to reflect this filter."
<-- Could you please clarify more details about the issue of your filter?
If possible, can you post some dummy data and measures you are using for further analysis?
Regards,
Jimmy Tao
- AndersMadsen
Alright, a little update.
I made it work.
All I had to do was put the [solved] column into the "Legend" part of the visual.
The only problem this gives is that I couldn't give the legend the name I wanted (solved, not solved) but was instead shown as "true" or "false". Changing the data labels so I showed percentage and category name was a solution though.