Forum Discussion

dtartaglia's avatar
dtartaglia
Icon for Resolver I rankResolver I
9 years ago

Line values measue in Line and stacked column chart visual

 

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

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      dtartaglia
      Icon for Resolver I rankResolver I
      9 years ago

      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')