version control
1 Topic
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 KartikSolved355Views0likes1Comment