Forum Discussion
How to get the Total and Subtotal without Average Calculation
Hi everyone, So Im doing some measures in DAX, but for the total it shows me the average and not the total of each class (and unit) I thing the problem is that Im using AVERAGE in the measure, but ...
Try these:
Rate =
VAR _Packages = VALUES('Table'[PackageID])
RETURN
SUMX(_Packages,CALCULATE(AVERAGE('Table'[Rate])))
Revenue =
VAR _Packages = VALUES('Table'[PackageID])
RETURN
SUMX(_Packages,CALCULATE(DIVIDE(AVERAGE('Table'[Cut]), 5) * COUNT('Table'[Units])))
Let me know if that isn't what you were looking for.
Connect on LinkedIn
I get the same result
In your first post you were showing Class at the top of the hierarchy and indicated you wanted to calculate at the package level and sum to the class level. In this latest post you are showing Package at the top and are indicating you want to calculate at the Unit and roll up to the above levels:
Modify the measures I gave before to this (swapping Package for Units):
Rate Measure = VAR _Units = VALUES('Table'[Units]) RETURN SUMX(_Units,CALCULATE(AVERAGE('Table'[Rate])))Is that what you are looking for?