Flexibility to use the same visual but show different value.

[CJANE]

I have a data set that includes two columns.  1 column represents gross total returrn and the second column representing net total return.  I need the flexibility to show the top ten performing funds for both gross and net returns using the same visual.  Ideally the user wants the ability to see top ten gross and then have the ability to see net top ten using the same visual.  Keep in mind that the top ten can differ between gross and net.  Any help would be appreciated.

[v-qiuyu-msft · Accepted solution]

Hi @CJANE,

If I understand correctly, you want to get top10 of GrossTotal and top10 NetTotal in one visual. I create some data, and display those data in a table visual, see:

1. Sample data.

2. In Query Editor, select those two columns and click Unpivot Columns.

3. Create a table with below DAX.

Table = UNION(CALCULATETABLE(TOPN(10,FILTER('Table2',[Attribute]="GrossTotal"),[Value],DESC)),CALCULATETABLE(TOPN(10,FILTER('Table2',[Attribute]="NetTotal"),[Value],DESC)))

Best Regards,

Qiuyun Yu