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.

SecurityACRPartner

Data source: AzureDashboardAS

EVALUATE
SUMMARIZECOLUMNS
(
'Partner'[Partner ID],
'Partner'[Partner Name],
'Partner Overlap'[Partner Attribution Type],
'Account Information'[TPID],
'Account Information'[Top Parent],
'Geography'[Area],
'Geography'[Subsidiary],
'Azure FRA Group'[Strategic Pillar],
'Service Comp Grouping'[Service Comp Grouping],
'Azure Service'[Service Level 2],
'Azure Service'[Service Level 4],
'Azure Subscription'[Tier 1 CSP],
'Azure Subscription'[Tier 2 CSP],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
FILTER('ACR Adjustment Type','ACR Adjustment Type'[ACR Adjustment Type]=="N/A"),
FILTER('Service Comp Grouping','Service Comp Grouping'[Service Comp Grouping]="Security"),
"ACR",[Azure Consumed Revenue],
"Azure Consumed Revenue Paid Units",[Azure Consumed Revenue Paid Units]
)