Forum Discussion

jhowe1's avatar
jhowe1
Helper III
5 years ago
Solved

Reference measure in another calculation

I have a measure which simply switches values depending on which currency is selected as bottom query, how do I calculate a percentage of this value, or reference NSV in any other measure? Say for ex...
Need Help
  • jhowe1's avatar
    jhowe1
    5 years ago

    This was close however I needed to use calculate as SUM wouldn't work and filter by whole product table not referencing a column. 

     

    % of NSV = DIVIDE( [NSV] , CALCULATE ( [NSV] , ALL ('30 Product' )))
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi jhowe1 

I'm not really clear on the problem.  You've created a measure called NSV and you want to know how to reference that in another measure?  Exactly as you have e.g.

 

SomeMeasure = DIVIDE( [NSV] , 1)

 

Regards

Phil

  • jhowe1's avatar
    jhowe1
    Helper III
    5 years ago

    Thanks for the response, I cannot do below it says 'parameter is not the correct type' and errors. I can only sum physical column, not measure.

     

    % of NSV =
    SUM ( [NSV] )
    / CALCULATE (
    SUM ( [NSV] ),
    ALL ( '30 Product'[Product] )
    )