Forum Discussion
lherbert501
3 years agoPost Prodigy
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...
- 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
OwenAuger
3 years agoSuper User
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
- lherbert5013 years agoPost Prodigy