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
MattAllingtonany ideas? I thought this would be simple to solve although its proving much more difficult than I thought
- MattAllington
Community Champion
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 UniqueSitesFantastic MattAllington this is perfect, exactly what I needed! Thank you so much.