Forum Discussion
Divide and TOP 10
Hi everyone! I have 1 table in excel with 3 columns Amount1 - Amount2 - Provider I've create a new column in Power BI that makes the difference between Amount1 and Amount2 Lets call it D...
What do you need the top 10 for? Is this to limit how many you display on a grid or in a visual?
If so you can do this using report fiters. If this works for you your DAX calc can be much simplier and if you provide a small sample of your data we can help with that.
Sorry, can't find where is that part you show in the image
Sorry, here is a slightly taller picture. When you drag an item to the Axis of a visual, down in the Filters you have additional options to filter that Axis. Here you can select the Top (or Bottom) N based on other values.
Sorry, still can't find the filter.
See right at the very bottom of your image, the Filter Type drop dow says "Advanced Fitlering". What happens when you click that?