Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a card title on my report which shows users the company they have selected when using filters - However if they select more than one company it will only show the last company selected. I would like this to just say "Multiple Companies Selected" if more than 1 is.
The current dax measure I have is:
Solved! Go to Solution.
Hi @JayTG123 ,
Please try this:-
Measure =
IF (
ISFILTERED ( 'Street Works Applications & Works'[Organisation] ),
IF (
COUNTROWS ( VALUES ( 'Street Works Applications & Works'[Organisation] ) ) > 1,
"Multiple Companies Selected",
MAX ( 'Street Works Applications & Works'[Organisation] )
),
"Kent Totals"
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @JayTG123 ,
Please try this:-
Measure =
IF (
ISFILTERED ( 'Street Works Applications & Works'[Organisation] ),
IF (
COUNTROWS ( VALUES ( 'Street Works Applications & Works'[Organisation] ) ) > 1,
"Multiple Companies Selected",
MAX ( 'Street Works Applications & Works'[Organisation] )
),
"Kent Totals"
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |