How to refer to a page filter when creating a column?

[danyeungw]

I want to create a column that if the use select a single customer from the PAGE filter, the column display the customer name. If the use select multiple or all customers, the column displays "Multiple".  I did the following but it didn't work. I think it was looking for the filter from the current visual. 

SelectedCustomer = IF(ISFILTERED(Customer[CustomerName]), Customer[CustomerName], "Multiple")

Appreciate you help. Thanks.

[v-mengzhu-msft · Accepted solution]

Hi @danyeungw ,

I do the test and get this result, is this meet your needs?

you can try this measure:

Measure = IF(COUNTROWS(VALUES('Table'[custom name]))=1,SELECTEDVALUE('Table'[custom name]),"MUTIPLE")

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[danyeungw]

Thanks Arul,
I changed to the following. It always has "Multiple" when I filtered the CustomerName at page level or visual level. 

SelectedCustomer = IF(HASONEVALUE(DSTrends[CustomerName]) = TRUE(), SELECTEDVALUE(DSTrends[CustomerName]), "Multiple")

[Arul]

@danyeungw ,

try this,

Customername = IF(HASONEVALUE('Customer Lookup'[customer_first-name]) = TRUE(),SELECTEDVALUE('Customer Lookup'[customer_first-name]),"Multiple")

Thanks,

Arul