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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I got your point but I am trying to avoint charts and covering space in report.

Please check my first description where my DAX is not returning data.

Calculated Column1:= var StudentCount1 = CALCULATE ( DISTINCTCOUNT(FactGrades[DimStudentsWid]), FILTER ( VALUES( FactGrades[PercentGradeReceived]) , COUNTROWS ( FILTER ( 'DimReportingConfig', FactGrades[PercentGradeReceived] >= 'DimReportingConfig'[MinValue] && FactGrades[PercentGradeReceived] < 'DimReportingConfig'[MaxValue]&&NOT(ISBLANK(FactGrades[PercentGradeReceived])) ) ) > 0 ) ) RETURN IF ( HASONEVALUE(SelectiomTable[Type]), SWITCH ( VALUES( SelectiomTable[Type] ), "SchoolYear", CALCULATE ( StudentCount1, TREATAS ( VALUES( SelectiomTable[VALUES] ),SectionEnrollment[SchoolYear] ) ), "GradeLevel", CALCULATE ( StudentCount1, TREATAS ( VALUES( SelectiomTable[VALUES] ), SectionEnrollment[GradeLevel]) ) ),0 )

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous, 

 

From your source data (https://drive.google.com/file/d/1jFr3cfSQbZemjFuKX50gLS45qlQ0R0Bq/view), the table FactGrades doesn't contain Type and VALUEs columns, I guess you do transform for the table in Query Editor. 

 

As I don't know how the data model it is, it's hard to provide further help. If possible, please share the pbix file and clarify the desired results of Calculated Column1. 

 

Best Regards,
Qiuyun Yu