Forum Discussion
SUM and Filter
I just posted one, but I couldn't find it. I will delete it after I find it.
Table
------------------------------------------
City Computer Count I II III
Toronto C 1 1 0 0
Toronto C 1 1 0 0
Toronto C 1 0 1 0
Toronto C 1 0 0 1
Toronto D 1 1 0 0
Toronto D 1 1 0 0
Toronto D 1 1 0 0
Ottawa A 1 0 1 0
Ottawa A 1 0 1 0
Ottawa B 1 0 0 1
-------------------------------------------------------------
Using matrix, In the report page, we can get the following table
City Computer Sum of Count Sum of I Sum of II Sum of III
-------------------------------------------------------------------------------------
Ottawa A 2 0 2 0
Ottawa B 1 0 0 1
Toronto C 4 2 1 1
Toronto D 3 3 0 0
------------------------------------------------------------------------------------
Total 10 5 3 2
Now I want to make a new measure: the first row 2/10, the second row 1/10, the 3rd row 4/10, the 4th row 3/10.
It is the second column divide 10 (the sum of second column).
We can use the following expression CALCULATE(SUM(Count), all('Table')) to get 10.
But this expression doesn't change if we use filter. For example, we can choose Toronto only using City filter. But this expression is 10, no matter how to adjust it.
I can't finish it. Please help.
Anonymous change ALL to ALLSELECTED
3 Replies
- parry2k
Super User
Anonymous change ALL to ALLSELECTED
- AnonymousNot applicable
Only changed one word ALL.
Super User is Super!!!
- AnonymousNot applicable
I need your help. Please take a look at it.