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
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()