Forum Discussion

TejeshGour's avatar
TejeshGour
Frequent Visitor
7 years ago

Need help in DAX

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 w...
Dashboards
TejeshGour's avatar
TejeshGour
Frequent Visitor
7 years ago

FactTable

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)

TejeshGour's avatar
TejeshGour
Frequent Visitor
7 years ago


SchoolYear will be fix category and remaining will be based on selection

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    7 years ago

    Hi TejeshGour, 

     

    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