Forum Discussion
Solved
Using a measure as a filter for another measure
Hi In the example below, I'm trying to create a measure to count the number of SiteRefs where the cumulative value of size is greater than 0: So the correct answer would be 4 for Januar...
You should never attempt such a problem without a dimension table on the site.
Try this
Measure = SUMX(VALUES(UniqueSites[Site]),if([Site Size Cumulative] >0,1,0))Note the new dimenstion table called UniqueSites
Thanks Greg. Sorry probably wasn't 100% clear. The matrix in the original post shows the cumulative values by month for each SiteRef. What I am trying to do is come up with a way to count the number of SiteRefs in each month that have a cumulative size greater than zero.
Not sure what you are referring to by [column] in your reply?
Greg_Deckler following your advice I've got part of the way there! I've created a measure which works without context....what I cannot work out is why an error is produced when context is added
Regards
Andy