https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-percentage-above-specific-amount/m-p/3015182#M102369 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="497795" data-lia-user-login="rigginb" class="lia-mention lia-mention-user">rigginb</a>&nbsp;</P><P>try to write a measure like this:</P><LI-CODE lang="python">Pct = VAR _count = COUNTROWS( FILTER(TableName, TableName[Agent Answer Time]&gt;=15) ) VAR _countall =COUNTROWS(ALL(TableName[Agent Answer Time])) RETURN DIVIDE(_count, _countall)</LI-CODE> Thu, 12 Jan 2023 00:20:52 GMT FreemanZ 2023-01-12T00:20:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-percentage-above-specific-amount/m-p/3015166#M102367 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I need a formula to calculate the percentage above 15 seconds in this column. Thanks in advance!</P><P>&nbsp;</P><P><img /></P> Thu, 12 Jan 2023 00:12:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-percentage-above-specific-amount/m-p/3015166#M102367 rigginb 2023-01-12T00:12:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-percentage-above-specific-amount/m-p/3015182#M102369 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="497795" data-lia-user-login="rigginb" class="lia-mention lia-mention-user">rigginb</a>&nbsp;</P><P>try to write a measure like this:</P><LI-CODE lang="python">Pct = VAR _count = COUNTROWS( FILTER(TableName, TableName[Agent Answer Time]&gt;=15) ) VAR _countall =COUNTROWS(ALL(TableName[Agent Answer Time])) RETURN DIVIDE(_count, _countall)</LI-CODE> Thu, 12 Jan 2023 00:20:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-percentage-above-specific-amount/m-p/3015182#M102369 FreemanZ 2023-01-12T00:20:52Z