Forum Discussion

jhowe1's avatar
jhowe1
Icon for Helper III rankHelper 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
Icon for Super User rankSuper User
5 years ago

Hi jhowe1 

I'm not sure what your data looks like but assuming '30 Product'[Product] contains numbers try this

 

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

 

[NSV] is already a SUM of values so you don't need to do it again.

If this doesn't work please supply some sample data so I can see your table structure.

Regards

Phil

jhowe1's avatar
jhowe1
Icon for Helper III rankHelper III
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' )))