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     🙂

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

 

As per your example, the logic is the fixed cost of equipment divided by the count of equipment. 

 

Try this 

 

Avg fixed cost = 
var _count= COUNT('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

    hi nandukrishnavs & Greg_Deckler  thanks for replying,

     

    The solution nandukrishnavs  has given worked at the selected or filtered level.

    But what I actually want is, the count for coresponding equipment in the entire data set to remain constant.

     

    Hence should give me constant fixed cost for individual equipment, irrespective of any filter I apply

    • nandukrishnavs's avatar
      nandukrishnavs
      Icon for Community Champion rankCommunity Champion
      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. 🙂