### Creating a Calculated measure based on other Calculated measures

Hi, I need help creating a calculated measure. I have two calculated measures A and B. They are just counts. I need to create a ...
| 4 Replies | 3277 Views | Created by Femi2006 - Friday, March 30, 2012 4:45 PM | Last reply by Martin Mason - Thursday, April 5, 2012 12:40 PM

### Complex Calculated Measure Issue

, 2nd col - calculated measure value April 3rd - May 2nd,...,last col - calculated measure value from May 2nd - May 31st). Initially I thought I ...
| 1 Replies | 4191 Views | Created by Gareth Collins - Tuesday, June 24, 2008 7:12 PM | Last reply by Tomislav Piasevoli - Tuesday, June 24, 2008 10:52 PM

### Hiding measures in SSAS 2012

created to remove the measures from the cube and just leave the calculated suppressed figures behind, or any way to tell SSAS to process the calculated ...
| 1 Replies | 873 Views | Created by Bunta80 - Wednesday, October 1, 2014 3:07 PM | Last reply by RichardLees - Wednesday, October 8, 2014 12:28 AM

### Problem with added calculated Measures members qualifying on YTD, in kombination with MDX parameter

Problem: In a dataset i add 9 calculated members to measures (using WITH MEMBER). Half of them are are qualifyed YTD that are part of a ...
| 2 Replies | 1049 Views | Created by Brittoj - Tuesday, August 20, 2013 2:20 PM | Last reply by Orsolya Gal - MSFT - Tuesday, November 19, 2013 9:41 AM

### Two examples of SCOPE MDX: Why will one with calculated measures not work?

Hello, Below two examples of identical SCOPE staments. One works as expected. The other will not work. I think is has to do with the fact that these measures are ...
| 0 Replies | 10258 Views | Created by QTom - Thursday, June 4, 2009 3:51 PM

### Solve Order with Currency Conversion, Semi-Additive Measures and Time Comparison

a one to many (store in USD, calculate to all others) currency conversion on both additive and semi additive measures.  I could not use MeasureExpressions because of ...
| 2 Replies | 5133 Views | Created by jeffrey.burke - Thursday, November 12, 2009 4:52 PM | Last reply by jeffrey.burke - Wednesday, December 9, 2009 2:31 AM

### What's wrong with my dax formular

Hi all, I am trying to calculate a measure based on another measure. The Measure I already created is MsrValue. Then I tried to ...
| 1 Replies | 1345 Views | Created by marser2010 - Tuesday, September 17, 2013 6:31 PM | Last reply by Gerhard Brueckl - Wednesday, September 18, 2013 8:54 PM

### Calculated measure based on date range

measure that i have to create. I require a calculated measure that provides the Cost measure over the last 30 days. The calculated ...
| 1 Replies | 2326 Views | Created by TPBurger - Wednesday, November 28, 2012 9:09 AM | Last reply by Martin Mason - Wednesday, November 28, 2012 4:55 PM

### SSAS Calculated Member

Hi Rajesh, In MDX, you can create a calculated member, which is a member based on other members. You can define two kinds of calculated ...
| 2 Replies | 928 Views | Created by Rajesh S Hegde - Thursday, December 26, 2013 10:29 AM | Last reply by Rajesh S Hegde - Friday, December 27, 2013 8:16 AM

### Measure calculation based on member properties at level in a user hierarchi

statement you recomended does not support a replacment for Measures.[X] with the formula for the other calculated member, so the whole calculation ...
| 4 Replies | 3959 Views | Created by Mial - Wednesday, October 7, 2009 9:06 AM | Last reply by Mial - Monday, October 19, 2009 12:17 PM

### 80th Percentile Calculation in MDX

is that i want to be able to combine this percentile measure with other summaried data.  The problem is that the way that the percentile measure works is by ...
| 1 Replies | 4450 Views | Created by netsmurph - Wednesday, November 24, 2010 6:24 AM | Last reply by Raymond-Lee - Friday, November 26, 2010 7:21 AM

### How can I create a calculated measure based on a filtered dimension?

(in the process of ordering a book just now) and having a crack at creating a calculated measure, which should sum a value from one of my Fact tables, based on a ...
| 2 Replies | 2762 Views | Created by GShenanigan - Thursday, November 15, 2012 10:30 AM | Last reply by GShenanigan - Thursday, November 15, 2012 2:17 PM

### wrong calculation of measure when the value is zero

Hi, I have a calculated measure which calculates based on DimSite. The calculation is as below - CREATE ...
| 2 Replies | 3036 Views | Created by Anirban Biswas - Thursday, October 1, 2009 6:52 AM | Last reply by Anirban Biswas - Thursday, October 1, 2009 8:25 AM

### Essbase measure shown as (null) in ReportBuilder query designer - bug

Interestingly enough, if we create a calculated field in the Query Designer based directly on a measure that comes back with (null), ...
| 1 Replies | 5058 Views | Created by Rimstalker - Friday, August 21, 2009 6:32 PM | Last reply by Lasse Miettinen - Wednesday, October 23, 2013 1:34 PM

### How to dynamically determine hierarchy of a dimension?

Hi, I have a dimension with attribute hierarchies and several other hierarchies with levels defined. I would like to know within the calculation, what is ...
| 2 Replies | 4422 Views | Created by HasanainK - Wednesday, August 5, 2009 7:55 PM | Last reply by HasanainK - Thursday, August 6, 2009 1:38 PM

### Cube Calculations and Report Model Problems

(as well as many other additive measures).  As it stands now, we've also stored percentages in the table (although this could be removed and calculated within the ...
| 0 Replies | 7050 Views | Created by Dan L - Tuesday, December 27, 2005 5:00 PM

### Quick calculation question

Member CurrentCube.[Measures].[Growth in Customer Base] As
| 0 Replies | 5300 Views | Created by Aiwa - Friday, April 27, 2007 3:45 PM

### TOP 10 from a table

(Student[Marks]) The TOPN function returns the top rows, based on a measure. In our case, this will be ...
| 1 Replies | 614 Views | Created by Rahul Sherawat - Monday, December 21, 2015 5:12 AM | Last reply by Michiel Rozema - NL - Monday, December 21, 2015 8:27 AM