Forum Discussion

Frequent Visitor

3 years ago

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 ...

Regular Visitor

3 years ago

majo23

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