sumproduct

2 Topics

Is there a way to create measure to Sum of Product measure?
I have Table A Snapshot ID.1 ID.2 Avg Demand 2/12/2024 1 A 20 2/12/2024 2 A 30 1/12/2024 3 B 40 Table B Snapshot ID.1 LT 2/12/2024 1 2 2/12/2024 2 3 There is a data connection between table A & B on ID.1 2 Slicers to select the snapshot for Table A & Table B I have created a Measure to calculate LT* Avg Demand Now I want to create another measure which do WT LT* Avg Demand i.e., SUM(LT*Avg Demand) instead of SUM(LT)* SUM(Avg Demand) at ID.2 level. Sort of do first row wise calculation of LT* Avg Demand and then sum it at ID.2 level. As current measure is doing SUM(LT)*SUM(Avg Demad). Thanks Kartik
Solved
Anonymous
2 years ago Place DAX Commands and Tips
357Views
0likes
1Comment
Establishing a MarginBridgeAnalyser
I am developing a margin bridge analyser, as I have done this succesfully in excel. I have several measures that I use like the price variance, but when it comes to the price efffect which is basically the sumproduct (as I would use in excel) of column quantity_baseperiod and price variance (defined in measure as AveragePrice Analysis Period - AveragePrice Base Period ....per item). I ahve researched and the proposal is to use sumx function in dax but this is not very happy about using measures in the calculation...
HenrikStrand
2 years ago Place DAX Commands and Tips
1.6KViews
0likes
5Comments