Hello all,
I have questions. Let's say I have an interface as below.
My intention is that whenever I click one of the country, "Name" will return Lists of selected Country combine both Logistic and Retail name such as below table called "All List"
I try to use the expressions Valid If "All List[Logistic Name]"but only one column return. How do I return value both Logistic and Retail Name whenever I click the Country? What expressions should I use?
Solved! Go to Solution.
You can simply concatenate the two columns using "+" operator.
You also want to filter on the Country column and exclude blank values, so try something like
SELECT(
All List[Logistic name],
AND(
[Country] = [_ThisRow].[Country],
ISNOTBLANK([Logistic Name]
)
)
+
SELECT(
All List[Retail Name],
AND(
[Country] = [_ThisRow].[Country],
ISNOTBLANK([Retail Name]
)
)
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |