Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX title

Hi,

 

How can I change this Dax measure so that it works when multiple things are selected?

 

Title =
"Sales Report for "
& IF (
CALCULATE (DISTINCTCOUNT ( Detail[Division] ),ALL ( 'Detail'[Division] ))
= CALCULATE (DISTINCTCOUNT ( Detail[Division] ), ALLSELECTED ( Detail[Division] )),
"UK",SELECTEDVALUE (Detail[Division] )) & " "
& SELECTEDVALUE ( 'Date Table'[year].[Year] ) & " "
 
If i select more than one division it just says "sales report for " 
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You could simply use "IN VALUES(column)" instead of "= selectedvalue(column)".

    You could use IN {string1, string2,...} if you need to manually enter the strings.

     

    Best Regards,

    Jay

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , not very clear but concatenatex can help

    use this in place of SELECTEDVALUE (Detail[Division] )) 

     

    concatenatex (allselected(Detail[Division] ), Detail[Division] )

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    You could simply use "IN VALUES(column)" instead of "= selectedvalue(column)".

    You could use IN {string1, string2,...} if you need to manually enter the strings.

     

    Best Regards,

    Jay