comapring
1 Topic
Count Not existing values in last quarter
Hello, I can't compare values over time like i would like. I have queries to retrieve distinct resellers each month : Resellers QTD = var _max = maxx(ALLSELECTED(Revenue),Revenue[Period]) return TOTALQTD( DISTINCTCOUNT('Partner'[Reseller Ref]), DATESQTD(Revenue[Period]), FILTER('Partner','Partner'[Date Validation] <=_max && 'Partner'[Date End] >=_max) ) Resellers Q-1 = var _max = maxx(ALLSELECTED(Revenue),Revenue[Period]) return TOTALQTD( DISTINCTCOUNT('Partner'[Reseller Ref]), DATEADD(Revenue[Period],-1,QUARTER), FILTER('Partner','Partner'[Date Validation] <=_max && 'Partner'[Date End] >=_max) ) ... After i use my measures to retrieve diff net value: Net New QTD = [Resellers QTD]-[Resellers Q-1] Net New Q-1 = [Resellers Q-1]-[Resellers Q-2] ... Now i would like to retrieve the distinct NEW resellers. This mean if i have a DISTINCT('Partner'[Reseller Ref]) exists @ QTD but not present in Q-1, i would like to count him. I tried something like this but it seems not working: Expension Q-1 = CALCULATE( [Resellers Q-1], FILTER('Subscription Partner', [Resellers Q-1] <> [Resellers Q-2]) ) Any idea ? I don't want the NET NEW !Solved895Views0likes1Comment