Forum Discussion
Helper IDuplicated entries when set multipe selection in filter
Hi,
I have a Table A contains 2 columns - Internal Severity, external Severity. They have same value options (Low, Medium, High, Critical). I created another table B with 1 column of SeverityValue (Low, Medium, High, Critical)
A:
| Problem ID | Internal Severity | External Severity |
| 1 | Critical | High |
| 2 | Medium | Medium |
| 3 | Low | Critical |
| 4 | High | Low |
| 5 | High | Medium |
B:
| SeverityValue |
Critical |
| High |
| Medium |
| Low |
I have a measurement X=Caculate([measure1], A[Internal Severity] IN allselected (B[SeverityValue])
I set B[SeverityValue] as a page filter. When choosing a single value from B[SeverityValue]
When choosing a single value from this filter, the table visualization works well. But if I select multiple entries,.
Single value : Critical
| Problem ID | Internal Severity | External Severity | SeverityValue | X |
| 1 | Critical | High | Critical | 1 |
Multiple value: Critical, High
| Problem ID | Internal Severity | External Severity | Severity Value | X |
| 1 | Critical | High | Critical | 1 |
| 1 | Critical | High | High | 1 |
| 4 | High | Low | Critical | 1 |
| 4 | High | Low | High | 1 |
| 5 | High | Medium | Critical | 1 |
| 5 | High | Medium | High | 1 |
My expected result is:
| Problem ID | Internal Severity | External Severity | Severity Value | X |
| 1 | Critical | High | Critical | 1 |
| 4 | High | Low | High | 1 |
| 5 | High | Medium | High | 1 |
Can someone help what I should change in my implementation?
Thanks!
3 Replies
HI e2liu77,
I'm not so clear for your requirement, can you please explain more about the logic to output the expected result? They should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
e2liu77Hi 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:
CALCULATE([measuremnt related to Internal Severity],'A'[Internal Severity] IN allselected ('B'[SeverityValue]), ...........)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
