could someone please help me achieve the calculate measure?
my client wants sum of highest and high and Divide by total…
so, in table below: 30+75 = 105 /267X100…
Used measures:
Hi, @Anu
Welcom to the eazyBI community.
The “All Priority” row shows all the priorities, not only high and highest.
For the upper level to show only the high and highest, please define the new member in the Priority dimension using Aggregated function.
The formula should look something like this:
Aggregate(
{
[Priority].[Highest],
[Priority].[High]
}
)
Kindly,
Ilze support@eazybi.com