Forum Discussion
Create average measure
Hi, NDG
Try this:Measure2 = AVERAGEX( FILTER( ALL( 'Table (2)' ), [Manufacturing Plant] = MAX( 'Table (2)'[Manufacturing Plant] ) ), [_Req Ship - Sched Ship] )[_Req Ship - Sched Ship] is a measure now.
_Req Ship - Sched Ship = SUM('Table (2)'[Req Ship - Sched Ship])Result:
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, NDG
Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented?
For example, you have Table 1, Table 2, and Table 3, and you attach the table data, and then you want to get Table 4. This makes it easier for people to understand your problem.
And It would be great if there is a sample file without any sesentive information here.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good day,
Let’s try to be clearer. I need to get average days for delta Scheduled Ship Date–Requested ship date that needs to be an additional measure.
Now the source to get to this information are 3 tables, from one I get the Manufacturing Plant from other Sales Product Category and last the delta of Ship Date – Requested ship date which is a measure from last one.
I need to have averaged as measure same as example pivot bellow
Average of Req Ship - Sched Ship
Manufacturing Plant
Sales Product Category
Total
ANT
ALUM ELEC AXIAL
19
ALUM ELEC RADIAL
26
ALUM POLY SMD
107
P5 STACKED
133
POWERBOX
112
PULSE
126
RFI FILM RADIAL
119
SINGLE-ENDED E-LYTIC
93
SMD-ELECTROLYTIC
67
SNAP-IN
105
ANT Total
118
BTM
FILM RADIAL
157
P5 STACKED
119
PULSE
136
RFI FILM RADIAL
173
BTM Total
149
EVE
ALUM ELEC AXIAL
38
ALUM ELEC RADIAL
57
SCREW TERMINAL
135
SNAP-IN
236
EVE Total
103
KYU
FILM RADIAL
138
FILM SPECIAL
175
LMC
106
POWER CANS
87
PULSE
118
RFI FILM RADIAL
103
KYU Total
109
MCD
FILM RADIAL
128
FILTERS
202
LMC
252
POWER AXIAL
161
POWER BRICK
191
PULSE
167
RFI FILM RADIAL
129
MCD Total
148
SAS
FILM RADIAL
54
FILM SMD
100
FILM SPECIAL
9
P5 STACKED
49
PFC
72
POWERBOX
100
POWER BRICK
73
POWER CANS
99
SAS Total
92
SSM
FILM RADIAL
27
FILM SMD
45
FILM SPECIAL
-
PAPER OTHER
166
PULSE
57
RC PAPER
67
RFI FILM RADIAL
82
RFI PAPER RADIAL
47
SSM Total
58
Grand Total
120
Can’t load a power bi file or excel as an example, I hope pivot will work.
Thank you and let me know if anything else is needed
- v-angzheng-msft
Hi, NDG
Try to create a measure like this:Measure 2 = CALCULATE( AVERAGE('Table (2)'[Req Ship - Sched Ship]), ALLEXCEPT('Table (2)','Table (2)'[Manufacturing Plant]))Result:
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thanks, v-angzheng-msft, can't use AVERAGE as Req Ship -Scheduled Ship is a measure, power bi doesn't let me.
