DAX Formulas
AccountID:
Formula
%ofFormType = [NumAccounts]/[AllForms]
Measure
AllForms = CALCULATE([NumAccounts], ALLSELECTED(AccountID[Forms]))
Measure
AtIDNumLicCount = CALCULATE(sum(Instance[LicenseCount]), USERELATIONSHIP(AccountID[AccountIDKey],Instance[AccountID]), FILTER(Instance,Instance[IsTerminated]=0))
Measure
AvgLicCountbyMarket = CALCULATE(AVERAGE(Instance[LicenseCount]), VALUES(Account[MarketLUTType]), FILTER(Instance,Instance[IsTerminated]<1))
Measure
AvgNumInstances = CALCULATE(COUNTA(Instance[InstanceID]), VALUES(Instance[AccountID]), USERELATIONSHIP(AccountID[AccountIDKey],Instance[AccountID]), AccountID[NumInstances]>1)
Measure
ClPurchaseDL = CALCULATE(sum(Baseload1[CloudPurchase]), USERELATIONSHIP(AccountID[AccountIDKey],Baseload1[AccountIDKey]))
Measure
ClTrialDL = CALCULATE(sum(Baseload1[CloudTrial]), USERELATIONSHIP(AccountID[AccountIDKey],Baseload1[AccountIDKey]))
Measure
NumAccounts = COUNTROWS(AccountID)
Measure
NumInstances = CALCULATE(COUNTROWS(Instance), USERELATIONSHIP(AccountID[AccountIDKey],Instance[AccountID]))
Column
PurchaseRate = [ClPurchaseDL]/[ClTrialDL]
Measure
GA_SessionData
AllFormComp = sum(GA_SessionData[AllGoals])
Measure
FormConvRate = [AllFormComp]/[TotalSessions]
Measure
TotalSessions = sum(GA_SessionData[Sessions])
Measure