Percentage calculation with Label

[Ignacio Amoros]

Hi,

Let me share my problem with eazyBI. I need to calculate the following percentage:

Hours from issues with Label=FWK / Total number of hour of all issues.

It seem easy but it is not, although the number of label = FWK it is correctly shown in Rows but when trying to complete the formula in Measures, the value it is never coming.

I attach a document for more clarification.

Thank you.
Ignacio.

[Ignacio Amoros · Accepted solution]

The correct second screenshot is:

[Measures].[Horas Framework vs Total %] =

[Measures].[Horas Framework]/[Measures].[Hours spent]

[Janis Plume _eazyBI_ · Accepted solution]

Hi,

The recommended solution is to use the standard calculation for the percentage of total:

In this case, note that Label is a multi-value field, and hours are counted for all labels the issue has.

The formula of a custom measure if you wish to avoid the use of the Label dimension in the report:

([Measures].[Hours spent],
[Label].[FWK])
/
([Measures].[Hours spent],
[Label].DefaultMember)

Kindly,

Janis, eazyBI support

[Ignacio Amoros]

Thank you so much! I will try that.

Best regards.

[Ignacio Amoros]

Hi Janis,

That formula is what I definitely needed. Thank you so much.

Best regards.

Ignacio.

[Ignacio Amoros]

Sorry, there was a mistake in my screenshot. This is the correct one.