Forum Discussion
Create a measure that return a string value from a column depending on selected value
MrAdrien , In measure you have use aggregation
example
DescPersona = maxx('Issues New',
IF(
SELECTEDVALUE(Personas[PType]) ="Manager",
'Issues New'[DescManager],
IF(
SELECTEDVALUE(Personas[PType]) ="Developer",
'Issues New'[DescDeveloper],
IF(
SELECTEDVALUE(Personas[PType])="Tester",
'Issues New'[DescTester],
'Issues New'[Description]
)
)
) )
Thank you for your quick answer.
Good news : measure is not in error
Bad news : it return blank results
Maybe to add information
I have like 1000 issues in the table 'Issues New'
Only 30 of them have manager, developer, tester description
The graphic timeline display only issues with specific metadata filtered (Priority, country, etc...) from 'Issues New' table
The graphic timeline is build by giving
The title of the issue
The due date of the issue
The description of the which is here the measure we are trying to build
To give more insight the issue new table look like this
| Issue ID | Description | DescManager | DescDeveloper | DescTester |
| 1 | Info 1 | |||
| 2 | Info 2 | |||
| 3 | [manager] they will.....[/manager] [developer]they get... [/developer] [testers]....[/testers] | They will | they get.... | ..... |
| ... | Info... | |||
| 1000 | Info 1000 |