weaselmcguff
Board Regular
- Joined
- Feb 24, 2006
- Messages
- 246
I am trying to create a Dynamic Title and coming up with errors.
My field has 2 different values
Conversion
Install
Here is my DAX Formula:
Title Combined = if(
ISFILTERED('Current'[Install Type]),
"Selected Type is " & CONCATENATEX('Current','Current'[Install Type],", "),
"Nothing Has Been Selected")
I get no errors, But when i select 1 or 2 of the values i get
Select Type is Install, Install, Install, Install, Install, Install, Install, Install, Install, Install,
It just keeps going even if i select Conversion first then i select Install i get the same as above.
If I only select Conversion it gives my Conversion in place of Install.
I want it to show
Selected Type is Conversion
Selected Type is Install
Selected Type is Install, Conversion
What am i doing wrong?
Thanks for your assistance
My field has 2 different values
Conversion
Install
Here is my DAX Formula:
Title Combined = if(
ISFILTERED('Current'[Install Type]),
"Selected Type is " & CONCATENATEX('Current','Current'[Install Type],", "),
"Nothing Has Been Selected")
I get no errors, But when i select 1 or 2 of the values i get
Select Type is Install, Install, Install, Install, Install, Install, Install, Install, Install, Install,
It just keeps going even if i select Conversion first then i select Install i get the same as above.
If I only select Conversion it gives my Conversion in place of Install.
I want it to show
Selected Type is Conversion
Selected Type is Install
Selected Type is Install, Conversion
What am i doing wrong?
Thanks for your assistance