Dynamic Text using multiple slicers

[Anonymous]

Hi,

I'm trying to set up a card visualization as a page header to display what is selected in each slicer. My current measure is giving me what I want, but only when I have items selected in the slicers. In the example below, if I remove the Dept Name "AMC BIRTH CTR", then every Dept Name is displayed on the page header. I want no Dept Name to display if nothing is checked in that slicer. Here is my current measure:

Title Measure 2 = "OPERATIONS DATA - " &  CONCATENATEX(VALUES(DateDim[Fiscal Year]),DateDim[Fiscal Year]," & ") & ", "
    & CONCATENATEX(VALUES(DateDim[Month Name]), DateDim[Month Name]," & ") & ", "
    & CONCATENATEX(VALUES(EncounterDetail[Patient Class]),EncounterDetail[Patient Class], " & ") & ", "
    & CONCATENATEX(VALUES(EncounterDetail[DC Dept Name]),EncounterDetail[DC Dept Name]," & ") & ", "
    & CONCATENATEX(VALUES(EncounterDetail[DC Service]),EncounterDetail[DC Service], " & ")

I'm sure I'm using the wrong function but I don't know what to use instead. If nothing is selected in any slicer, then the header should only read "OPERATIONS DATA". As you select items in the slicers, those items will appear to the right of the original header. Below is the report so you have a better understanding of what I'm talking about. Look at the slicer section on the right side and the page header up top. 

 Thank you!

[Greg_Deckler]

You need to do some IF(HASONEVALUE(...)) type stuff. I would do those in VAR statements and then concatenate together.

[Anonymous]

Thanks, Greg. The problem with using IF(HASONEVALUE...) is you're allowed to check more than one box in each slicer. If you check two months in the Month slicer, then it disappears from the text. Do you have any other ideas? Thank you!!

[Anonymous]

Does anyone else have an idea of how to write this measure? I'm stumped. Please and thank you!!

[Greg_Deckler]

Try ISFILTERED instead.

[Anonymous]

So I tried this but it only gives me my first row, Fiscal Year.  The other slicers do not display.

Title Measure = "OPERATIONS DATA " & IF(ISFILTERED(DateDim[Fiscal Year]),CONCATENATEX(VALUES(DateDim[Fiscal Year]),DateDim[Fiscal Year]," & ") & ", "
    & IF(ISFILTERED(DateDim[Month Name]),CONCATENATEX(VALUES(DateDim[Month Name]), DateDim[Month Name]," & ") & ", "
    & IF(ISFILTERED(EncounterDetail[Patient Class]), CONCATENATEX(VALUES(EncounterDetail[Patient Class]),EncounterDetail[Patient Class], " & ") & ", "
    & IF(ISFILTERED(EncounterDetail[DC Dept Name]), CONCATENATEX(VALUES(EncounterDetail[DC Dept Name]),EncounterDetail[DC Dept Name]," & ") & ", "
    & IF(ISFILTERED(EncounterDetail[DC Service]), CONCATENATEX(VALUES(EncounterDetail[DC Service]),EncounterDetail[DC Service], " & ")    )))))

I'm not very fluent in DAX so maybe my syntax is incorrect. Any help is greatly appreciated. Thank you!!