Aggregating calculated measure in a dimensional report

[David_Efr]

Hi all,

I'm not an expert in multidimensional reporting and need some help.


I have a dimension with 2 levels: "Vendor" and "Invoice".
I have measures "Invoice Total" and "Invoice Count".
I also have a parameter "prmThreshold".

I'd like to display a table, showing the percentage of invoices per Vendor, that their total exceeds the specified threshold.
I have a

In a relational report, I'd simply create a data item with an expression:

Code Select Expand

IF
    ([business_view].[Invoice Data].[Invoice Total] > ?prmThreshold?)
THEN
    (1)
ELSE
    (0)
and set the aggregation to Total, but in a dimensional report this simply doesn't work - the condition is applied to the total of "Invoice Total" for each "Vendor" and you just get 1.

I tried to have the "Invoice" level in the query and then aggregate the values with a query reference, but it just runs forever.

Any suggestions?
I have a feeling, that a dimensional function can solve it, but none of my attempts worked so far.

Thanks,
David