https://community.fabric.microsoft.com/t5/Developer/GT-and-Rank/m-p/211781#M6685 <P>thank you.</P> Fri, 14 Jul 2017 05:52:26 GMT Ashley1022 2017-07-14T05:52:26Z https://community.fabric.microsoft.com/t5/Developer/GT-and-Rank/m-p/205798#M6536 <P><BR />Hi,&nbsp;<BR />I have a requirement of computing for the %GT Value based on Securities in the Base table below and display the Top 3 values. However, when the ranking &nbsp; filter is applied, %GT Value recalculates based on the Top 3 selected value only (refer to 2nd table below).&nbsp; Is there a way i can display the %GT values without considering the Top 3 filter (refer to Preferred Output table)?Thank you in advance.</P><P>&nbsp;</P><P>&nbsp;</P><P>Base table&nbsp;&nbsp;&nbsp;<BR />Security &nbsp; &nbsp; Value &nbsp;&nbsp; %GT Value&nbsp;<BR />C1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 44 &nbsp; &nbsp; &nbsp; &nbsp; <FONT color="#0000ff">29.93%&nbsp;</FONT><BR />D1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33 &nbsp; &nbsp; &nbsp;&nbsp; <FONT color="#0000ff">22.45%&nbsp;</FONT><BR />B1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 24 &nbsp; &nbsp; &nbsp;&nbsp; <FONT color="#0000ff">16.33%&nbsp;</FONT><BR />A1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 23 &nbsp; &nbsp; &nbsp; &nbsp; 15.65%&nbsp;<BR />D1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; &nbsp; 8.16%&nbsp;<BR />D2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 7.48%&nbsp;<BR /><BR />&nbsp;&nbsp;&nbsp;<BR />Top 3: Visual filter applied&nbsp;&nbsp;&nbsp;<BR />Security&nbsp;Value &nbsp; &nbsp;&nbsp; %GT Value &nbsp; &nbsp;&nbsp; Rank<BR />C1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 44 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; <FONT color="#ff6600">43.56%</FONT> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1<BR />D1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 33 &nbsp; &nbsp; &nbsp; &nbsp; <FONT color="#ff6600">32.67%</FONT> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2<BR />B1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 24 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; <FONT color="#ff6600">23.76%</FONT> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<BR /><BR />&nbsp;&nbsp;&nbsp;<BR />Preferred Output&nbsp;&nbsp;&nbsp;<BR />Security &nbsp; &nbsp; &nbsp; Value &nbsp; &nbsp;&nbsp; %GT Value &nbsp; &nbsp; Rank<BR />C1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 44 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; <FONT color="#0000ff">29.93% &nbsp;</FONT> &nbsp; &nbsp; 1<BR />B1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; <FONT color="#0000ff">22.45%</FONT> &nbsp; &nbsp; &nbsp; 2<BR />D1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <FONT color="#0000ff">16.33%</FONT> &nbsp; &nbsp; &nbsp;&nbsp; 3</P> Tue, 04 Jul 2017 08:28:36 GMT https://community.fabric.microsoft.com/t5/Developer/GT-and-Rank/m-p/205798#M6536 Ashley1022 2017-07-04T08:28:36Z https://community.fabric.microsoft.com/t5/Developer/GT-and-Rank/m-p/206204#M6541 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/32142">@Ashley1022</a></P> <P>Instead of auto calculation, create a measure instead.</P> <PRE>GT Value measure = SUM(yourTable[Value])/CALCULATE(sum(yourTable[Value]),ALL(yourTable))</PRE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 600px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/48666i8B8C9141CB40C3FF/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Wed, 05 Jul 2017 03:21:25 GMT https://community.fabric.microsoft.com/t5/Developer/GT-and-Rank/m-p/206204#M6541 Eric_Zhang 2017-07-05T03:21:25Z https://community.fabric.microsoft.com/t5/Developer/GT-and-Rank/m-p/211781#M6685 <P>thank you.</P> Fri, 14 Jul 2017 05:52:26 GMT https://community.fabric.microsoft.com/t5/Developer/GT-and-Rank/m-p/211781#M6685 Ashley1022 2017-07-14T05:52:26Z