Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
3 years ago
Solved

Dynamic Title Field Parameter

Hi,   I have my measure below which it accepts the dax okay.   TESTDynamicTitle = VAR a =     CALCULATE ( DISTINCTCOUNT ( DimDate[Month] ), ALLSELECTED ( DimDate[Month] ) ) VAR b =     CALC...
  • OwenAuger's avatar
    3 years ago

    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