Forum Discussion
Anonymous
6 years agoNot applicable
Help with creating a complex measure
I need to create a measure for a model sampled as below Equipment Fixed Cost.Fix Cost Origin Name 16P ₹ 9,00,000 Ameenpur 12P ₹ 25,000 Atmakuru 10P ₹ 4,50,000 Atmakuru 14P...
- 6 years ago
Anonymous
Try this
Avg fixed cost = var _count= COUNTROWS(FILTER(ALL('Table'),'Table'[Equipment]=SELECTEDVALUE('Table'[Equipment]))) var _fixedcost= SELECTEDVALUE('Table'[Fixed Cost.Fix Cost]) var _result= DIVIDE(_fixedcost,_count,BLANK()) return _result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Greg_Deckler
Community Champion
6 years agoAnonymous So put EquipmentFixed in a Table visualization and use the default Average aggregation for Cost.Fix?