I have a fact table with 8 measures that aren't always all available. I'd like to aggregate them with AVG() so I tried to create a calculated member:
where I1 is the measure (aggregated by sum) and #Indexes is a count of rows automatically created by SSAS. But obviously the #Indexes includes all rows, also the ones with empty measures.
M1 M2 ...
I have to have 10 as AVG rollup of M1 in this small table and now I'm getting 5.
how could I solve this?
View Complete Post