Request for help: I have two columns 'type' and 'VALUES' (in screenshot) in table and another table is facttable that contains detail so that i am trying to show similer data in Calculated Column1 which will show measure only. I have written below expresssion but I am not getting data even not getting any error. Please have a look on return condition.
I am trying to create dynamic category using slicer component. Below is expression to created table in SSAS TOM MODEL: var Race= CROSSJOIN(ROW("Type","Race"), VALUES(DimStudents[RaceName])) var Gender= CROSSJOIN(ROW("Type","Gender"), VALUES(DimStudents[GenderName])) var Hispanic = CROSSJOIN(ROW("Type","Hispanic"), VALUES(DimStudents[HispanicName])) var SchoolYear= CROSSJOIN(ROW("Type","SchoolYear"), VALUES(SectionEnrollment[LatestSchoolYear])) var SchoolName= CROSSJOIN(ROW("Type","SchoolName"), VALUES(DimSchool[SchoolName])) return UNION(Race,Gender, Hispanic,SchoolYear,SchoolName)
The FactTable link is not accessible. Please double check it.
For your screenshot, it looks like there are four legends (Gender, Race, SchoolYear, SchoolName) display in the chart, you would like to keep the SchoolYear displaying regardless any filter will filter out SchoolYear, right? I'm afraid this is not supported currently.
Best Regards, Qiuyun Yu
Community Support Team _ Qiuyun Yu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.