Forum Discussion
SUM, Filter by Two Columns text values
Hi Anonymous
Try this measure:
Measure = VAR _filter_from_Start = FILTER( 'Table', [Start Street] = "1st street" || [Start Street] = "2nd street" || [Start Street] = "10th street" ) VAR _filter_from_End = FILTER( _filter_from_Start, [End Street] = "2nd street" || [End Street] = "3rd street" || [End Street] = "8th street" ) RETURN SUMX( _filter_from_End, [Distance Miles] )But the conditions is too long or in your data, is that possible to use start street not equal waterloo road?
If is , filter with the condition
[Start Street]<>”waterloo road”Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Could you provide some example data and expected output?
Hi,
Please see the requested below.
| Distance Miles | Start Street | End Street |
| 5 | 1st street | 2nd street |
| 6 | 1st street | waterloo road |
| 8 | 2nd street | waterloo road |
| 3 | waterloo road | 3rd street |
| 65 | 10th street | 8th street |
SUM of column 'Distance Miles;
Filter column 'Start Street' to = 1st street, 2nd street, 10th street
Filter column 'End Street' to = 2nd street, 3rd street, 8th street
Expexted outcome = 70
Hope this helps
Hi Anonymous
Try this measure:
Measure = VAR _filter_from_Start = FILTER( 'Table', [Start Street] = "1st street" || [Start Street] = "2nd street" || [Start Street] = "10th street" ) VAR _filter_from_End = FILTER( _filter_from_Start, [End Street] = "2nd street" || [End Street] = "3rd street" || [End Street] = "8th street" ) RETURN SUMX( _filter_from_End, [Distance Miles] )But the conditions is too long or in your data, is that possible to use start street not equal waterloo road?
If is , filter with the condition
[Start Street]<>”waterloo road”Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.