Forum Discussion
Filter not working as expected
Apologies for the delay in response, but a one to one relationship is not being allowed between "Type" and thus am not able to resolve it using this, thanks for your response.
Hi Anonymous ,
No,what I mean is to create a dimensional table between the 2 tables then create a one to one relationship as my sample show it.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi v-kelly-msft,
As I mentioned before, a one to one relationship is not being allowed between the "Type" dimension table and the other Table1 and Table2.
Hi Anonymous ,
Relationship is not the key factor,could you pls provide some sample data with expected output for test?
Best Regards,
KellyDid 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