DAX measure to dynamic title

[Pbiuserr]

Hello, 

Trying to do dynamic formula however got some obstacles

My DAX formula is as presented

DynamicTitle =

VAR _Count = COUNTROWS(VALUES('data'[PROJECT_KEY]))

VAR Concat = CONCATENATEX(VALUES('data'[PROJECT_KEY]),[PROJECT_KEY]," ,")

RETURN

IF(_Count = COUNTROWS(VALUES('data'[PROJECT_KEY])), "All selections",

IF(_Count >5 "Above 5 selections",Concat))

COUNTROWS(VALUES('data'[PROJECT_KEY])) gives proper amount of projects key's. The point is I think it should be differently inserted here IF(_Count = COUNTROWS(VALUES('data'[PROJECT_KEY])), "All selections" - so it says that if all project keys are selected then (..)

Any suggestions?

[ValtteriN · Accepted solution]

Hi,

As things stand your _count and "All selections" have the same syntax.  If you include ALL in your DAX when it comes to "All selections" your code should work. E.g. IF(_Count = COUNTROWS(VALUES(ALL('data'[PROJECT_KEY]))), "All selections",

[Pbiuserr]

Hello,

It works, thank you 🙂 just as i though

I have one additional problem though. When I filter by other slicer, the name of the label changes automatically as well. Can I prevent it, so only filtering this one particular slicer (project key) enables to change title dynamically?

edit: okay I found out edit interaction option