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.
Solved! Go to 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
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
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")
try this,
Customername = IF(HASONEVALUE('Customer Lookup'[customer_first-name]) = TRUE(),SELECTEDVALUE('Customer Lookup'[customer_first-name]),"Multiple")
Thanks,
Arul
User | Count |
---|---|
136 | |
58 | |
55 | |
55 | |
46 |
User | Count |
---|---|
130 | |
73 | |
55 | |
54 | |
50 |