Line values measue in Line and stacked column chart visual

[dtartaglia]

Hi,

I'm still pretty new to DAX but this measure used to work to display the below red line specified in the Line values field:

Studio Goal = if (DISTINCTCOUNT(SurveyDataTransposed[Tool])>1, 0, VALUES(CombinedStudioSkillTables[Studio Skill Goal Index]))

It's now causing the below error. Is there a better DAX statement I should use?

Thanks,

Dan

[Anonymous]

HI @dtartaglia,

I modified your formula to deal with the result which has multiple index.(it will return 0)

Studio Goal = 
if (DISTINCTCOUNT(SurveyDataTransposed[Tool])>1, 0, 
if(COUNTROWS(VALUES('Table'[UK Financial Year]))>1,0,
VALUES(CombinedStudioSkillTables[Studio Skill Goal Index]))
)

Regards,

Xiaoxin Sheng

[dtartaglia]

Hi Xiaoxin,

Thanks for the reply. Your logic produces the same issue ans mine. It may or may not have to do with using UNION to compbine my tables:

CombinedStudioSkillTables = UNION('Columbus 55', 'Columbus 55x', 'Columbus 99x', 'Seattle 41x', 'London 01x', 'Admin 00x', 'Boston 01x', 'Graphics 07x', 'New York 01x', 'Los Angeles 01x', 'San Francisco 01x', 'Seattle Healthcarex', 'Seattle 09x', 'Seattle 31x', 'Shanghai 01x')