Forum Discussion
Solved
Average based on columns
Good day, Will need help as I’m new with DAX. How I can get average measure based on measure output whereas condition to be used different columns entries. Exs. Table 1 as condition to b...
Hi NDG ,
You can try this measure to calculate the average:
Average = VAR tab = SUMMARIZE ( 'Table 1', 'Table 1'[Sales Product Category], 'Table 2'[Plant], 'Table 3'[Order date], "A", [Measure] ) RETURN AVERAGEX ( tab, [A] )Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi NDG ,
You can try this measure to calculate the average:
Average =
VAR tab =
SUMMARIZE (
'Table 1',
'Table 1'[Sales Product Category],
'Table 2'[Plant],
'Table 3'[Order date],
"A", [Measure]
)
RETURN
AVERAGEX ( tab, [A] )
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
