Forum Discussion
Filter not working as expected
Hi Anonymous ,
Relationship is not the key factor,could you pls provide some sample data with expected output for test?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi v-kelly-msft,
What essentially happens is this:
There is a table "A" which consists of id, type, date, a few questions.
Another table "S" consists of id, type, date (month and year format) with the number of types per month.
I need to plot a graph for number of A per month and S per month.
But A doesn't directly have number of rows per month, for which I use SUMMARIZECOLUMNS to achieve the same (say R).
The page has filters from A (type and date) which need to be able to filter out the graph consisting S and R.
A isn't filtering out R itself even with a many to many relationship between types.
Attaching screenshots for A and R.
Original dataSummarized data