I am trying to find the average sales by day if the flag value in dimension is Y or N. I am able to do it without Y or N and its working fine. But i dont know how to get average when flag value(whichis in flag_dimension). Here is my data model is attached.
The overallAvg below column i found it by a calculated member by followign 3 steps.
1. Find sum of price measures
2. Find the count
3. Sum/count and this gave me exact result.
But what if i want to find average only if FlagA is Y and average when FlagA is Y and flagB is Y/N.
Any help will be greatly appreciated.