Forum Discussion

milpro011's avatar
milpro011
Helper I
7 years ago

Matrix Table Sub Totals NOT Computing for a Measure

Hi,  I have the following Measure devised to compute dynamic buckets:  PlaceBucketMP = SUMX( ADDCOLUMNS( PlaceBuckets, "BucketsTotal", COUNTROWS( FILTER( ...
Need Help
milpro011's avatar
milpro011
Helper I
7 years ago

v-xicai Many thanks!

The blacked out items are PlaceARs.

 

This is the new measure that I created: 

PlaceBucketTot = 
VAR _table = SUMMARIZE(Student_Place_History,[PlaceAR], "_Value", [PlaceBucketMP])
RETURN IF(HASONEVALUE(Student_Place_History[PlaceAR]),[PlaceBucketMP],SUMX(_table,[_Value]))

But I got this error:

The query referenced calculated column 'Student_Place_History'[PlaceBucket] which does not hold any data because there is an error in its expression.

 

What I'm trying to achieve is to figure out how many [PlaceARs] do we have that have "Placed" more than 7 students, between 7 and 14, as per the "PlaceBuckets" table provided above. 

 

Once again, thank you for helping me. 

milpro011's avatar
milpro011
Helper I
7 years ago

v-xicai I actually changed the second measure to point to the bucket table, and it returned no errors, yet it is still not summing up. 

 

PlaceBucketTot = 
VAR _table = SUMMARIZE(PlaceBuckets,[Placements], "_Value", [PlaceBucketMP])
RETURN IF(HASONEVALUE(PlaceBuckets[Placements]),[PlaceBucketMP],SUMX(_table,[_Value]))

Thanks!