% of total measure in TOP N Table

[smpa01]

Hello Experts,

I have a table (Table1) as following

Column1

10

20

80

I did a measure on that which is following to get the % of total

Measure = SUM(Table1[Column1])/CALCULATE(SUM(Table1[Column1]),ALLSELECTED())

it gives me following

Now I created a another TOPN table as following which gives me this

Table = TOPN(2,'Table1',[Column1])

Is it possible to get the measure from Table 1 in the TOPN table as following

Column1	Measure
20	0.18
80	0.73

Thank you in advance.

[v-shex-msft · Accepted solution]

HI @smpa01 ,

You can use all function to replace allselected function in your formula:

Measure = SUM(Table2[Column1])/CALCULATE(SUM(Table1[Column1]),ALL(Table1))

Regards,

Xiaoxin Sheng

[smpa01]

@v-shex-msftgreat thanks !!!