Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
how do I write this as a Dax expression?
=sum(field X * field Y)/sum(Field X)
I get an error that the sum function in only expecting one field.
Solved! Go to Solution.
@22LACMT Try:
= SUMX('Table',[field X] * [field Y])/ SUM([field X)
@22LACMT Try:
= SUMX('Table',[field X] * [field Y])/ SUM([field X)
Sorry, it its still giving me errors . I added a filter but am still getting incorrect data
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |