xxxxxxxxxx
Order Profile =
CALCULATETABLE (
SUMMARIZE (
'Sales Table',
'Sales Table'[Order_Num_Key],
Customer[Sector],
"Total Value", SUM ( 'Sales Table'[Net Invoice Value] ),
"Order Count", DISTINCTCOUNT ( 'Sales Table'[Order_Num_Key] )
),
YEAR ( DimDate[Datekey] ) = YEAR ( TODAY () )
)