topic how to calculate 10% of the values of a column + 0.1 ? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-10-of-the-values-of-a-column-0-1/m-p/2006035#M44583 <P>Hi all,&nbsp;</P><P>&nbsp;</P><P>First time here <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>I have a table with CPU, RAM, STO Usable values.</P><P><img /></P><P>I need to have a calculation in the GAUGE CPU 10% column to create for each CPU Usable value a threshold correspondant value with this calculation, directly in my PowerBI desktop:<BR />CPU usable value * 10%+0.1<BR />same for RAM and STO.<BR />How can I format this in my Power BI?<BR />Thanks for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 09 Aug 2021 14:48:56 GMT colinec22 2021-08-09T14:48:56Z how to calculate 10% of the values of a column + 0.1 ? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-10-of-the-values-of-a-column-0-1/m-p/2006035#M44583 <P>Hi all,&nbsp;</P><P>&nbsp;</P><P>First time here <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>I have a table with CPU, RAM, STO Usable values.</P><P><img /></P><P>I need to have a calculation in the GAUGE CPU 10% column to create for each CPU Usable value a threshold correspondant value with this calculation, directly in my PowerBI desktop:<BR />CPU usable value * 10%+0.1<BR />same for RAM and STO.<BR />How can I format this in my Power BI?<BR />Thanks for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 09 Aug 2021 14:48:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-10-of-the-values-of-a-column-0-1/m-p/2006035#M44583 colinec22 2021-08-09T14:48:56Z Re: how to calculate 10% of the values of a column + 0.1 ? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-10-of-the-values-of-a-column-0-1/m-p/2006083#M44585 <P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726" target="_blank">How to Get Your Question Answered Quickly - Microsoft Power BI Community</A></P> Mon, 09 Aug 2021 14:35:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-10-of-the-values-of-a-column-0-1/m-p/2006083#M44585 Anonymous 2021-08-09T14:35:33Z