cancel
Showing results for
Did you mean:
Prashasti Frequent 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 and total points covered in that iteration. I have calculated the median and percent(Divided total points of each iteration by the median calculated) as follows: Media =
MEDIANX (
SUMMARIZE ( Data, Data[Iteration] ),
CALCULATE ( SUM ( Data[Points] ) )
)
Percent =
DIVIDE ( SUM ( Data[Points] ), CALCULATE ( [Media], ALLSELECTED ( Data ) ) )

In my actual table there are many iterations and I need to display the top 6 iterations and get the score for them. The above calculation works if ALL(Data) is used instead of ALLSELECTED(Data). However, in my graph visualization(Custom Column Chart), upon selecting a particular iteration,the value of percent changes to 1 for all iterations.  Hoping you could help out here.

Thanks,

Prashasti

4 REPLIES 4 Super User

Re: Median Calculation in Table Visualization

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 Frequent Visitor

Re: Median Calculation in Table Visualization

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 Super User

Re: Median Calculation in Table Visualization

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() Community Support Team

Re: Median Calculation in Table Visualization

Hi @Prashasti,

Actually, current you can use table/matrix visual to 'highlight' interaction with other charts.(it seems like power bi not support to use other visual to highlight table/matrix visuals records)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Announcements Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge. Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform. Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag. Top Kudoed Authors
Users Online
Currently online: 99 members 1,429 guests
Recent signins:
• • MarkJames • michaelag • work2skiWA • junopowerbi • Anthea_TP • QuinnP • suddin • abnerfc01 • seacubs17 • qbaenkhbat • esposid • mandux • mleeker 