https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ratio-of-Filter-value-of-a-measure-total-measure/m-p/714100#M1148 <P>I am trying to see what % a department and/or Job Category Labor Cost is to the grand total.&nbsp; &nbsp;I have a couple of slicers for Department and Job Category on the same report and I want to create a card that shows the % as the Manager filters to the grand total of the Division.&nbsp; &nbsp;I have 1 measure [Labor Cost].&nbsp; &nbsp;Is there a way to do it based on how they slice the data?</P> Thu, 13 Jun 2019 13:17:06 GMT Anonymous 2019-06-13T13:17:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ratio-of-Filter-value-of-a-measure-total-measure/m-p/714100#M1148 <P>I am trying to see what % a department and/or Job Category Labor Cost is to the grand total.&nbsp; &nbsp;I have a couple of slicers for Department and Job Category on the same report and I want to create a card that shows the % as the Manager filters to the grand total of the Division.&nbsp; &nbsp;I have 1 measure [Labor Cost].&nbsp; &nbsp;Is there a way to do it based on how they slice the data?</P> Thu, 13 Jun 2019 13:17:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ratio-of-Filter-value-of-a-measure-total-measure/m-p/714100#M1148 Anonymous 2019-06-13T13:17:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ratio-of-Filter-value-of-a-measure-total-measure/m-p/714368#M1162 <P>Hello,</P><P>&nbsp;</P><P>It would be helpfull if you would provide some screenshots because your description is not clear enough.</P><P>&nbsp;</P><P>Regards,</P><P>&nbsp;</P><P>Adrian</P> Thu, 13 Jun 2019 17:54:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ratio-of-Filter-value-of-a-measure-total-measure/m-p/714368#M1162 avanderschilden 2019-06-13T17:54:48Z