Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |