I am currently working in power pivot to visualize data from a cube.In power pivot i use certain dimensions on filters for which default member is set. The data gets messed up when i select the default member in the filter
For Example :
Considering the dimension to be "Time" which has the following hierarchy (Year-> Quarter-> Month ->Week ->Date) and the default member is "Current Date".
In this case when ever i select the month which includes current date along with few other months.The aggregation that was specified for the measure doesn't works it just shows data for day level(default member) instead of aggregating the data for the combined
months that were selected ,but when i select other months excluding the month that contains the current date it works as expected.
This is the case with all the dimensions that contains default member and which are used in filters.
Is there any solution to solve this?
