Just need to average multiple dimension into one calculated field. also if there is a null value the average should not consider that in the calculation.
Thanks in advance.
What do you want to with this? Don't you mean a measure?
You can just use this formula, null() values are not calculated.
Actually, there is more than 1 measure.
I have attached an excel file that makes it easy to understand.
check that it is not considering null values. I need to do this in Table(Data Manager).
Thanks in Advance.