Dynamic Title Field Parameter

[lherbert501]

Hi,

I have my measure below which it accepts the dax okay.

TESTDynamicTitle =

VAR a =

    CALCULATE ( DISTINCTCOUNT ( DimDate[Month] ), ALLSELECTED ( DimDate[Month] ) )

VAR b =

    CALCULATE ( DISTINCTCOUNT ( DimDate[Month] ), ALL ( DimDate[Month] ) )

return

  "" &

  CONCATENATEX (

        VALUES ( 'Parameter'[Parameter] ),

       'Parameter'[Parameter],

        " ,")

    & " Sales for " & IF( a = b, FIRSTNONBLANK(DimDate[YearNumCal],1), FIRSTNONBLANK(DimDate[Month],1 ))

But when I put it into the dynamic title I get the below error. 

I've looked into Using SELECTEDVALUE with Fields Parameters in Power BI - SQLBI which looks similar, but I cant seem to get it to like the dax. Is there an alternative method?

Thankyou

[kaisrec]

@lherbert501 , is it possible to apply the same logic to column header?
Use a Function in Field Parameters Header - Microsoft Fabric Community

[OwenAuger · Accepted solution]

Hi @lherbert501 

The easiest fix would be to change

CONCATENATEX (
    VALUES ( 'Parameter'[Parameter] ),
    ...

into

CONCATENATEX (
    'Parameter',
    ...

Since there should be no duplicates in the 'Parameter'[Parameter] column, the result should be as intended.

Passing a field parameter column reference to VALUES suffers from the same underlying problem as passing one to SELECTEDVALUE.

Regards

[lherbert501]

Thankyou @OwenAuger 

It seems so simple now I see it! 😀