Forum Discussion
Solved
Add the average per different category
I have a simple data model as below: and each table has following values: Product Table: Device Number Design Code Prod-35282 R6PM06 Prod-35283 S6PM06 Prod-35284 T6PM06...
It does, but in a graphical way. Here's the same as a measure.
lbendlin Thanks. It works. May I ask why did you use MAX here? EARLIER was the first thing came to my mind, I used it but did not work.
EARLIER is a leftover from the time before DAX had "variables" (which aren't really variable, but that's another story). MAX was chosen arbitrarily in this scenario, any aggregation would have worked. It all depends on what makes sense for the total.