Calculate the total of a column as a calculated member

Questions & Answers
,
1

Hi, I am new to eazyBI, and I am trying to sum up hours spent on all user stories in a given PI, as part of a larger calculation.

I have looked at some other posts, but I can’t get it to work:
How to calculate Total Sum of Rows as a measure - Questions & Answers - eazyBI Community
Total column calculation - Questions & Answers - eazyBI Community
And “Calculate the sum of total row - Questions & Answers - eazyBI Community”

To clarify, I don’t need the total row functionality, but a total as a calculated member, so I can build upon the result.

Here is a picture trying to illustrate what I want to achieve:

image
image1395×749 140 KB

My “Time Spent On User Stories” looks like this:

([Measures].[Hours spent],
[Sprint.PI no].DefaultMember)
-
([Measures].[Hours spent],
 [Issue Type].[Sub Bug],
 [Sprint.PI no].DefaultMember)

How do I get the column “Total Time Spent On User Stories” to say 517.25 in all cells?

2

If I can improve my post, please let me know.

3

Hi,

The following formula gives the total of the measure:

Sum(
  VisibleRowsSet(),
  [Measures].[Time Spent On User Stories]
)

Note also that there are standard measures that might help for your use case:

image
image1192×426 45.1 KB

Kindly,
Janis, eazyBI support