Selected Value as a dynamic header

verneroberts — Mon, 24 Jul 2017 05:34:24 GMT

Most reports I make have a dynamic header using the Enlighten Data Story where I show which filter values the user has currently selected as they interact with the report.

Selected State = 
VAR __allLabel = "The U.S."
VAR __maxCount = 5
VAR __maxLabel = "multiple states"
VAR __totalCount = CALCULATE(DISTINCTCOUNT('Table'[State]),ALL('Table'))
VAR __selectedCount = DISTINCTCOUNT('Table'[State])
RETURN
	IF(		
		__selectedCount = 1,
		VALUES('Table'[State]), 
		IF (
			__selectedCount = __totalCount, 
			__allLabel,
			IF (
				__selectedCount > __maxCount,
				__maxLabel,
				CONCATENATEX(TOPN(__selectedCount-1,VALUES('Table'[State])),'Table'[State],", ") & " and " & LASTNONBLANK(VALUES('Table'[State]),true)
			)
		)
	)

topic Selected Value as a dynamic header in Quick Measures Gallery

Selected Value as a dynamic header