Count Not existing values in last quarter

Anonymous — Fri, 26 Feb 2021 09:57:43 GMT

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 !

Re: Count Not existing values in last quarter

amitchandak — Fri, 26 Feb 2021 11:15:39 GMT

Anonymous , Check these two blog on customer retention can help you get what you need

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

else

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

topic Re: Count Not existing values in last quarter in DAX Commands and Tips

Count Not existing values in last quarter

Re: Count Not existing values in last quarter