Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
DAX Calculation
divide
Help Requested
  • nandukrishnavs's avatar
    nandukrishnavs
    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     🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks nandukrishnavs, it worked just like I wanted.

I now understood how to use FILTER command,

I will much appreciate if you can please post some informative link to understand FILTER command and its applications.

 

Thanks again. 🙂