topic Re: Use values from Table visual in Developer https://community.fabric.microsoft.com/t5/Developer/Use-values-from-Table-visual/m-p/1445769#M26206 <P>Use HASONEVALUE() to figure out if your context is a single cell, a row or column total, or a grand total.&nbsp; Then create the measure you want for the grand total.&nbsp; How are you planning to display the result?&nbsp; Via CONCATENATEX() ?</P> Wed, 21 Oct 2020 01:34:23 GMT lbendlin 2020-10-21T01:34:23Z Use values from Table visual https://community.fabric.microsoft.com/t5/Developer/Use-values-from-Table-visual/m-p/1442640#M26178 <P>Hi All ,&nbsp;</P><P>&nbsp;</P><P>I have visual table in my report&nbsp; which consist of many measures from diferent tables . Thease measures i hvae displayed using&nbsp; Traffic light colors . Now i have to use this data to show summray .</P><P>&nbsp;</P><P>Example :</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; London&nbsp; &nbsp; &nbsp; &nbsp;Essex&nbsp; &nbsp; &nbsp; &nbsp;Liverpool&nbsp; &nbsp; &nbsp; &nbsp;Machestar</P><P>Site A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Green&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Green&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amber</P><P>Site B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Green&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red</P><P>&nbsp;</P><P>From the above&nbsp; i need to show how many green , red and amber are there in whole sleection.Please help.</P><P>&nbsp;</P><P>Regards</P><P>Salma</P> Mon, 19 Oct 2020 16:00:09 GMT https://community.fabric.microsoft.com/t5/Developer/Use-values-from-Table-visual/m-p/1442640#M26178 Anonymous 2020-10-19T16:00:09Z Re: Use values from Table visual https://community.fabric.microsoft.com/t5/Developer/Use-values-from-Table-visual/m-p/1445769#M26206 <P>Use HASONEVALUE() to figure out if your context is a single cell, a row or column total, or a grand total.&nbsp; Then create the measure you want for the grand total.&nbsp; How are you planning to display the result?&nbsp; Via CONCATENATEX() ?</P> Wed, 21 Oct 2020 01:34:23 GMT https://community.fabric.microsoft.com/t5/Developer/Use-values-from-Table-visual/m-p/1445769#M26206 lbendlin 2020-10-21T01:34:23Z