topic Any help here in Developer https://community.fabric.microsoft.com/t5/Developer/Any-help-here/m-p/347486#M10301 <P>On the table below, starting from Account till Descritpion (I will keep appending data) and i would need to use them as filter on the&nbsp;visualization.</P><P>&nbsp;</P><P>I want to calculate<SPAN>&nbsp;</SPAN><STRONG>Cost 1% and Cost 2 %</STRONG><SPAN>&nbsp;</SPAN>-<SPAN>&nbsp;</SPAN><U>Matching all the senarious or filter that i would select on the visual...</U></P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Account</TD><TD>Fiscal</TD><TD>Senario</TD><TD>Job type</TD><TD>Region</TD><TD>Geo</TD><TD>Location</TD><TD>Quadrant</TD><TD>Scenario Type</TD><TD>Scenario Type 1</TD><TD>Description</TD><TD>Split</TD><TD>H1</TD><TD>H2</TD><TD>Y</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Sales</TD><TD>100</TD><TD>100</TD><TD>100</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 1</TD><TD>50</TD><TD>50</TD><TD>50</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 2</TD><TD>20</TD><TD>20</TD><TD>20</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Sales</TD><TD>100</TD><TD>100</TD><TD>100</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 1</TD><TD>50</TD><TD>50</TD><TD>50</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 2</TD><TD>20</TD><TD>20</TD><TD>20</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Sales</TD><TD>100</TD><TD>100</TD><TD>100</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 1</TD><TD>50</TD><TD>50</TD><TD>50</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 2</TD><TD>20</TD><TD>20</TD><TD>20</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Sales</TD><TD>100</TD><TD>100</TD><TD>100</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 1</TD><TD>50</TD><TD>50</TD><TD>50</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 2</TD><TD>20</TD><TD>20</TD><TD>20</TD></TR></TBODY></TABLE> Mon, 29 Jan 2018 20:35:06 GMT games1 2018-01-29T20:35:06Z Any help here https://community.fabric.microsoft.com/t5/Developer/Any-help-here/m-p/347486#M10301 <P>On the table below, starting from Account till Descritpion (I will keep appending data) and i would need to use them as filter on the&nbsp;visualization.</P><P>&nbsp;</P><P>I want to calculate<SPAN>&nbsp;</SPAN><STRONG>Cost 1% and Cost 2 %</STRONG><SPAN>&nbsp;</SPAN>-<SPAN>&nbsp;</SPAN><U>Matching all the senarious or filter that i would select on the visual...</U></P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Account</TD><TD>Fiscal</TD><TD>Senario</TD><TD>Job type</TD><TD>Region</TD><TD>Geo</TD><TD>Location</TD><TD>Quadrant</TD><TD>Scenario Type</TD><TD>Scenario Type 1</TD><TD>Description</TD><TD>Split</TD><TD>H1</TD><TD>H2</TD><TD>Y</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Sales</TD><TD>100</TD><TD>100</TD><TD>100</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 1</TD><TD>50</TD><TD>50</TD><TD>50</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 2</TD><TD>20</TD><TD>20</TD><TD>20</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Sales</TD><TD>100</TD><TD>100</TD><TD>100</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 1</TD><TD>50</TD><TD>50</TD><TD>50</TD></TR><TR><TD>1</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 2</TD><TD>20</TD><TD>20</TD><TD>20</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Sales</TD><TD>100</TD><TD>100</TD><TD>100</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 1</TD><TD>50</TD><TD>50</TD><TD>50</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Budget</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 2</TD><TD>20</TD><TD>20</TD><TD>20</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Sales</TD><TD>100</TD><TD>100</TD><TD>100</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 1</TD><TD>50</TD><TD>50</TD><TD>50</TD></TR><TR><TD>2</TD><TD>FY 18</TD><TD>Actual</TD><TD>A</TD><TD>NA</TD><TD>US</TD><TD>T</TD><TD>P</TD><TD>R</TD><TD>R1</TD><TD>DDD</TD><TD>Cost 2</TD><TD>20</TD><TD>20</TD><TD>20</TD></TR></TBODY></TABLE> Mon, 29 Jan 2018 20:35:06 GMT https://community.fabric.microsoft.com/t5/Developer/Any-help-here/m-p/347486#M10301 games1 2018-01-29T20:35:06Z Re: Any help here https://community.fabric.microsoft.com/t5/Developer/Any-help-here/m-p/347842#M10306 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/52595">@games1</a>,</P> <P>&nbsp;</P> <P>If I understand you correctly, the formula below should&nbsp;work in your scenario.&nbsp;<img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://community.fabric.microsoft.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P> <PRE>Cost 1% = DIVIDE ( CALCULATE ( SUM ( 'Table1'[Value] ), FILTER ( 'Table1', 'Table1'[Split] = "Cost 1" ) ), CALCULATE ( SUM ( 'Table1'[Value] ), FILTER ( ALL ( 'Table1' ), 'Table1'[Split] = "Cost 1" ) ) ) </PRE> <P>Note: You'll need to replace 'Table' and [Value] with your real table name and column name.</P> <P>&nbsp;</P> <P>Regards</P> Tue, 30 Jan 2018 07:54:03 GMT https://community.fabric.microsoft.com/t5/Developer/Any-help-here/m-p/347842#M10306 v-ljerr-msft 2018-01-30T07:54:03Z