Forum Discussion

Prashasti's avatar
Prashasti
Frequent Visitor
7 years ago

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...
Need Help
AlB's avatar
AlB
Community Champion
7 years ago

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?

  • Prashasti's avatar
    Prashasti
    Frequent Visitor
    7 years ago

    Hi AlB,

     

    I need the percent to remain 0.33 as I'm using this to calculate a measure. I'm then using this measure to get the average with other measures. But When I filter based on iterations, the percent here changes, thereby resulting in a wrong score. I need to know if there's an alternative to AllSelected() or can I create a copy of this table which only has the top 10 values of iterations so that I can use All() on this copy of the table to get the expected result. 

    Hope this makes the issue clear. 

     

    Thanks,

    Prashasti

    • AlB's avatar
      AlB
      Community Champion
      7 years ago

      Hi Prashasti

      I'm still not very clear but if you need all the iterations to be taken into account in the denominator of [Percent] then you should use ALL() instead of ALLSELECTED()