Filtering using the same table as base
Hello To all I'm trying to show in a report info that should be filter by two values that are in the same table, if I do it as it is I get zero results (which is correct). How can I do this? ...
Forum Discussion
Hi Anonymous
It seems it's better to make auxiliary tables .
Regards,
Cherie
Hello v-cherch-msft
Just did. I breaked the table B in two
Table B1
id wid value type
1 1 2 1
3 2 5 1
4 3 3 1
6 4 8 1
Table B2
id wid value type
2 1 4 2
5 3 9 2
by using FILTER with type.
But now if I link them to table A will I not get the same result? Or am I beeing a newbie.
Thanks
Hi Anonymous
I reviewed your question and I think i cannot fully understand it. Why not use wid column in TableB as slicer to get it as below picture? Using type columns as slicers seems more complicated.
Regards,
Cherie
Hello v-cherch-msft
I cannot use wid because in fact what I need to display is the value of Table A filter by both types.
I need to get the wid that as both type 1 and type 2 and use that to get the value of Table A.
In SQL seems more easy... :)
Regards
Hi Anonymous
Check below picture if it matches your request. Add two slicers and add a measure for Table A. Here is the sample file.
Regards,
Cherie