Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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')
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |