Forum Discussion
Prashasti
7 years agoFrequent Visitor
Median Calculation in Table Visualization
Hello All, I have a table which has iteration and points covered in each iteration as shown below. I need to group the table as shown in figure 2. The second table contains distinct iterations an...
AlB
7 years agoCommunity Champion
Hi Prashasti
I'm not sure I understand the issue correctly but, isn't that what you would expect? If you select one of the iterations, the ALLSELECTED() in the denominator of your [Percent] measure restricts the [media] measure to only the selected iteration. Therefore [Percent] is 100%, since numerator and denominator yield the same.
What result were you expecting? What would you like to see when selecting only one iteration?