Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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+'Parámeter3'[Parameter A3]/100);
"A5";[ActualSales];
"A5";[ActualSales];
"A6";[ActualSales]*(1+'Parámeter4'[Parameter A4]/100);
[ActualSales])
It works perfectly, but in the total the sum is not correct, any idea?
Thanks a lot!!
Solved! Go to Solution.
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 ) ) ) ) )
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 ) ) ) ) )
Thanks so much!
By the way, you may help accept solution. Your contribution is highly appreciated.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |