Forum Discussion
Duplicated entries when set multipe selection in filter
Hi Anonymous ,
Thanks for your quick reply.
Simply saying, I have 2 columns (Internal Severity/External Severity) in table A with same value ranges (Low, Medium, High, Critical). I created another table B with the same values as a filter (SeverityValue). I want to show the measurements related to these 2 columns in one visualization with the second table B SeverityValue as a page filter.
In the measurement 1, I use:
When I choose a single value from filter B SeverityValue, the table format visualization shows the correct selected values. But if I choose multiple values from filter SeverityValue, the table visualization will show each entry "mutiple" times.
I wondered whether it is because there is no directly relationship between B SeverityValue and Table A. Do we have anyway to show only desired entries (without multiples) when choosing muitple values from SeverityValue.
Hi e2liu77,
I'd like to suggest you create a new measure formula to compare two field values(Internal Severity and your measure formula) and return flag, then you can use this measure on ‘visual level filter’ to use flag as condition to filter not matched records.
Regards,
Xiaoxin Sheng