Forum Discussion
sandragocj27
8 years agoFrequent Visitor
problem total sum with a measure
Hi everybody, I've got two related tables, and I'm trying to make this measure: TotalSales = switch(max(Service[ServiceType]); "A1";[ActualSales]; "A2";[ActualSales]; "A3";[ActualSales]*(1+'P...
- 8 years ago
Try with following
What is your firstColumn i.e the Column used to Group Values
TotalSales = IF ( HASONEFILTER ( TableName[ColumnusedasRowField] ), SWITCH ( MAX ( Service[ServiceType] ), "A1", [ActualSales], "A2", [ActualSales], "A3", [ActualSales] * ( 1 + 'Parámeter3'[Parameter A3] / 100 ), "A5", [ActualSales], "A5", [ActualSales], "A6", [ActualSales] * ( 1 + 'Parámeter4'[Parameter A4] / 100 ), [ActualSales] ), SUMX ( VALUES ( TableName[ColumnusedasRowField] ), CALCULATE ( SWITCH ( MAX ( Service[ServiceType] ), "A1", [ActualSales], "A2", [ActualSales], "A3", [ActualSales] * ( 1 + 'Parámeter3'[Parameter A3] / 100 ), "A5", [ActualSales], "A5", [ActualSales], "A6", [ActualSales] * ( 1 + 'Parámeter4'[Parameter A4] / 100 ) ) ) ) )
Zubair_Muhammad
8 years agoCommunity Champion
Try with following
What is your firstColumn i.e the Column used to Group Values
TotalSales =
IF (
HASONEFILTER ( TableName[ColumnusedasRowField] ),
SWITCH (
MAX ( Service[ServiceType] ),
"A1", [ActualSales],
"A2", [ActualSales],
"A3", [ActualSales]
* ( 1
+ 'Parámeter3'[Parameter A3] / 100 ),
"A5", [ActualSales],
"A5", [ActualSales],
"A6", [ActualSales]
* ( 1
+ 'Parámeter4'[Parameter A4] / 100 ),
[ActualSales]
),
SUMX (
VALUES ( TableName[ColumnusedasRowField] ),
CALCULATE (
SWITCH (
MAX ( Service[ServiceType] ),
"A1", [ActualSales],
"A2", [ActualSales],
"A3", [ActualSales]
* ( 1
+ 'Parámeter3'[Parameter A3] / 100 ),
"A5", [ActualSales],
"A5", [ActualSales],
"A6", [ActualSales]
* ( 1
+ 'Parámeter4'[Parameter A4] / 100 )
)
)
)
)
sandragocj27
7 years agoFrequent Visitor
Thanks so much!
- v-chuncz-msft7 years agoCommunity Support