Calculating top 20 from multiple measures

[KhrystinaM]

Hello, 

I have created multiple measures to get the count of each row. Those measures were added to a pie chart, but I only want to see the top 20 results. I am not sure how to acheive this. 

Measure formula: 

Advance Authority = CALCULATE(COUNTA('Missing Docs'[Missing Docs - Advance Authority]),'Missing Docs'[Missing Docs - Advance Authority] IN { "Advance Authority" })

[Fowmy]

@KhrystinaM 
From what you have done, I can see that you have created separate measures hard coding the values for the filed Missing Docs - Advance Authority.  I suggest you change the approach to creating a single measure wich will pick the Missing Docs - Advance Authority from the filter context. This way you will be able to use the Missing Docs - Advance Authority column in the legend of the chart. This will also allow you to show only the top 20 using an additional meaure. Please share a dummy file with data.

[KhrystinaM]

@Fowmy, thank you for your response. I had to create a measure for each miss document column. Advance Authority is one of around 80 missing doc columns. I'm not sure if your approach will work for me?

[KhrystinaM]

@johnt75, you helped out on this topic Solved: Rank multiple measures each with different calcula... - Microsoft Fabric Community and I'm wonding if my issue is the same? If so, how do I create a new fields parameter?