Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I would like to create calculated columns:
- averages per category (per supplier per country and per etim class) - this I can calculate.
- Where I got stuck is how to calculate the average of those values above, taken every supplier, country and etim class combination only once.
Example:
supplier_avg_co2_total: e.g for ABB, for MCB in France: (8+2+9+28)/4 - I can calculate this.
ETIM_country_avg:
that would show the average of supplier’s averages. In the example below for France and MCB: (11.75+6.67+14.16)/3
thank you!
Solved! Go to Solution.
This DAX works:
@bsz412 , Try a measure like
AverageX(Summarize(Table, Table[Country], Table[ETIM_country]), calculate([Suppier_Avg_col2_total], allexcept(Table, Table[Country], Table[ETIM_country])))
in case Suppier_Avg_col2_total is a column
AverageX(Summarize(Table, Table[Country], Table[ETIM_country]), calculate(Average([Suppier_Avg_col2_total]), allexcept(Table, Table[Country], Table[ETIM_country])))
hello @amitchandak ,
Thanks for your help! The DAX gives me this result:
same number for each row, probably the dax needs a bit fine-tuning, but I dont know how...
This DAX works:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |