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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
131 | |
81 | |
65 | |
61 | |
55 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |