Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
95 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
66 |