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
MattAllington
Community Champion
Community ChampionYou 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
Fantastic MattAllington this is perfect, exactly what I needed! Thank you so much.