Divide and TOP 10

Hi chrisgehm,

To your first question: divide Difference/Amount1, you said none of the two ways worked fine, can you describe more clearly? Any error prompt? Don't they give you the correct result? Or don't they give any value? Based on my test, both of these formulas worked well.

To your second question: get the TOP 10 of providers with the greatest Amount1. 

Please create a new table, refering to this DAX formula:

TopN = TOPN(10,Top10,TableName[Amount1],DESC)

Alternatively, you can also add visual level filters (not page level filter and report level filter) to display only Top 10 records. Pay attention, TopN option is only available under Visual level filters tab.

Best regards,
Yuliana Gu