This content has been marked as final. Show 2 replies
Let me have 20 dimensions (Sex, Year, Country ... etc 20 dimensions). I also have a measure of "Sales". All in a single table.
How do I calculate the amount of expression on the "Sales", ignoring all the dimensions, except for one of the dimensions. For example, the dimension of "Sex" should be considered.
If user choose Sex = 1 then the sum must be equal to 900;
If user choose Sex = 2 and Year = 2016 then the amount should be equal to 300;
If user choose Sex = 1 and Year = 2016 and Country = USA then the amount must be equal to 900;