Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

BizAppsConsumedValue

Data source: BizAppsAs

evaluate
summarizecolumns
(
'Account Information'[TPID],
Geography[Area],
Geography[Subsidiary],
'Account Information'[Sales Unit],
Segment[Segment Group],
Segment[SubSegment],
'Usage Source'[Usage Source Group],
'SKU'[SKU Group],
'SKU'[SKU],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Account Information'[Industry],
'Account Information'[Vertical],
filter('Metric Type','Metric Type'[Metric Type]="Paid"),
filter('Calendar','Calendar'[Fiscal Year]>="FY22"),
"BACV",[BizApps Consumed Value],
"Consumed Revenue Rate",IF(ISBLANK([BizApps Consumed Value]),BLANK(),MAX ( 'SKU'[Consumed Revenue Rate])),
"Monthly Active Usage",[Monthly Active Usage],
"Qualified Available Seats",[Qualified Available Seats],
"Qualified Assigned Seats",[Qualified Assigned Seats],
"Monthly Active Capacity",IF(SELECTEDVALUE('SKU'[SKU Group])="D365 CI Profiles",CALCULATE([Monthly Active Capacity],KEEPFILTERS('Usage Source'[Usage Source] <> "Customer Insights Partner")),[Monthly Active Capacity])
)