topic COUNTIFS SUMIFS Power Pivot in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547778#M72001 <P>Hi,</P><P>I am quite new ti this forum but what I see this forum is a treasure! I hope I can find an answer to my question as well!</P><P><SPAN>I am trying to solve my problem in power pivot by writing a measure; I have achieved to solve my problem actually using excel function but I want to solve it using dax and measure</SPAN><BR /><BR /><SPAN>In this data, there are years where problem occurred, event descriptions and finally lost hours.</SPAN><BR /><SPAN>As a rule, to call an event as a cause;</SPAN></P><UL><LI>Same event should happen 4 times or more in that year. In this case, total lost hours might be less than 8 hours</LI><LI>Same event might happen less than 4 times in that year. In this case, total lost hours should be more than 8 hours</LI><LI>Cause column is what I try to achive. I have achived by using following excel formula&nbsp;</LI><LI><SPAN>=IF(COUNTIFS(C:C,'UDT Analysis.xlsx'!#REF!,F:F,'UDT Analysis.xlsx'!#REF!)&gt;3,"Yes",IF(SUMIFS(D:D,C:C,'UDT Analysis.xlsx'!#REF!,F:F,'UDT Analysis.xlsx'!#REF!)&gt;7,"Yes","No"))</SPAN></LI></UL><P><SPAN>I will be so glad if you could help me to create a dax measure look similar to my excel formula. Thanks a lot for help and comments!</SPAN></P><TABLE><TBODY><TR><TD>Plant</TD><TD>Department</TD><TD>Description&nbsp;&nbsp;</TD><TD>Lost hours</TD><TD>Lost Tons</TD><TD>Year</TD><TD>Quarter</TD><TD>Month</TD><TD>Month Name</TD><TD>Week</TD><TD>Cause</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Low Pressure Pump A</TD><TD>2,6</TD><TD>221</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>21</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Chain Drive B</TD><TD>2,1</TD><TD>182</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>21</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Chain Drive A</TD><TD>0,8</TD><TD>68</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Chain Drive B</TD><TD>1,5</TD><TD>130</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>A1234TT</TD><TD>0,9</TD><TD>74</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>A1234TT</TD><TD>0,1</TD><TD>4</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>B758PT</TD><TD>0,6</TD><TD>42</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>B758PT</TD><TD>0,1</TD><TD>4</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>SDT</TD><TD>0,3</TD><TD>23</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Maintenance</TD><TD>SDT</TD><TD>0,4</TD><TD>26</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Roller</TD><TD>0,2</TD><TD>17</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Pump A</TD><TD>2</TD><TD>148</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Pump A</TD><TD>0,4</TD><TD>29</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Grinder B dwon</TD><TD>1</TD><TD>89</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Downtime&nbsp;</TD><TD>0,2</TD><TD>13</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Maintenance</TD><TD>Downtime&nbsp;</TD><TD>0,1</TD><TD>9</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Grinder B dwon</TD><TD>0</TD><TD>3</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>B758PT</TD><TD>0,3</TD><TD>29</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Start up after downtime</TD><TD>0,2</TD><TD>15</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Low Temperature Heater A</TD><TD>1,4</TD><TD>122</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>Sdt</TD><TD>17,1</TD><TD>1,265</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>Yes</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Low Temperature Heater A</TD><TD>0</TD><TD>2</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Roller</TD><TD>0,6</TD><TD>49</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>Sdt</TD><TD>24</TD><TD>1,775</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>Yes</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Bolt Pump A</TD><TD>0</TD><TD>3</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Bolt Pump A</TD><TD>1,6</TD><TD>138</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Valve problem&nbsp;</TD><TD>0,1</TD><TD>12</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>Valve problem&nbsp;</TD><TD>0,1</TD><TD>10</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>SDT</TD><TD>16,7</TD><TD>1,234</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>Yes</TD></TR><TR><TD>SRI</TD><TD>Maintenance</TD><TD>Broken Bolt Pump A</TD><TD>1</TD><TD>85</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>A1234TT</TD><TD>0</TD><TD>3</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Turbine failure</TD><TD>0,3</TD><TD>24</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Start up after downtime</TD><TD>1,1</TD><TD>91</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Turbine failure</TD><TD>0,7</TD><TD>63</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>19</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>No power</TD><TD>1,1</TD><TD>95</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>19</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>No power</TD><TD>0,9</TD><TD>78</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>19</TD><TD>No</TD></TR></TBODY></TABLE><P>&nbsp;</P> Mon, 30 May 2022 12:19:25 GMT Burak83_ 2022-05-30T12:19:25Z COUNTIFS SUMIFS Power Pivot https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547778#M72001 <P>Hi,</P><P>I am quite new ti this forum but what I see this forum is a treasure! I hope I can find an answer to my question as well!</P><P><SPAN>I am trying to solve my problem in power pivot by writing a measure; I have achieved to solve my problem actually using excel function but I want to solve it using dax and measure</SPAN><BR /><BR /><SPAN>In this data, there are years where problem occurred, event descriptions and finally lost hours.</SPAN><BR /><SPAN>As a rule, to call an event as a cause;</SPAN></P><UL><LI>Same event should happen 4 times or more in that year. In this case, total lost hours might be less than 8 hours</LI><LI>Same event might happen less than 4 times in that year. In this case, total lost hours should be more than 8 hours</LI><LI>Cause column is what I try to achive. I have achived by using following excel formula&nbsp;</LI><LI><SPAN>=IF(COUNTIFS(C:C,'UDT Analysis.xlsx'!#REF!,F:F,'UDT Analysis.xlsx'!#REF!)&gt;3,"Yes",IF(SUMIFS(D:D,C:C,'UDT Analysis.xlsx'!#REF!,F:F,'UDT Analysis.xlsx'!#REF!)&gt;7,"Yes","No"))</SPAN></LI></UL><P><SPAN>I will be so glad if you could help me to create a dax measure look similar to my excel formula. Thanks a lot for help and comments!</SPAN></P><TABLE><TBODY><TR><TD>Plant</TD><TD>Department</TD><TD>Description&nbsp;&nbsp;</TD><TD>Lost hours</TD><TD>Lost Tons</TD><TD>Year</TD><TD>Quarter</TD><TD>Month</TD><TD>Month Name</TD><TD>Week</TD><TD>Cause</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Low Pressure Pump A</TD><TD>2,6</TD><TD>221</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>21</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Chain Drive B</TD><TD>2,1</TD><TD>182</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>21</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Chain Drive A</TD><TD>0,8</TD><TD>68</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Chain Drive B</TD><TD>1,5</TD><TD>130</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>A1234TT</TD><TD>0,9</TD><TD>74</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>A1234TT</TD><TD>0,1</TD><TD>4</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>B758PT</TD><TD>0,6</TD><TD>42</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>B758PT</TD><TD>0,1</TD><TD>4</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>SDT</TD><TD>0,3</TD><TD>23</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Maintenance</TD><TD>SDT</TD><TD>0,4</TD><TD>26</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Roller</TD><TD>0,2</TD><TD>17</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Pump A</TD><TD>2</TD><TD>148</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Pump A</TD><TD>0,4</TD><TD>29</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Grinder B dwon</TD><TD>1</TD><TD>89</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Downtime&nbsp;</TD><TD>0,2</TD><TD>13</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Maintenance</TD><TD>Downtime&nbsp;</TD><TD>0,1</TD><TD>9</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Grinder B dwon</TD><TD>0</TD><TD>3</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>B758PT</TD><TD>0,3</TD><TD>29</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Start up after downtime</TD><TD>0,2</TD><TD>15</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Low Temperature Heater A</TD><TD>1,4</TD><TD>122</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>Sdt</TD><TD>17,1</TD><TD>1,265</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>Yes</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Low Temperature Heater A</TD><TD>0</TD><TD>2</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Roller</TD><TD>0,6</TD><TD>49</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>Sdt</TD><TD>24</TD><TD>1,775</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>Yes</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Bolt Pump A</TD><TD>0</TD><TD>3</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Broken Bolt Pump A</TD><TD>1,6</TD><TD>138</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Valve problem&nbsp;</TD><TD>0,1</TD><TD>12</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>Valve problem&nbsp;</TD><TD>0,1</TD><TD>10</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>SDT</TD><TD>16,7</TD><TD>1,234</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>Yes</TD></TR><TR><TD>SRI</TD><TD>Maintenance</TD><TD>Broken Bolt Pump A</TD><TD>1</TD><TD>85</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>A1234TT</TD><TD>0</TD><TD>3</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Turbine failure</TD><TD>0,3</TD><TD>24</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Start up after downtime</TD><TD>1,1</TD><TD>91</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>20</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Production</TD><TD>Turbine failure</TD><TD>0,7</TD><TD>63</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>19</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>No power</TD><TD>1,1</TD><TD>95</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>19</TD><TD>No</TD></TR><TR><TD>SRI</TD><TD>Other</TD><TD>No power</TD><TD>0,9</TD><TD>78</TD><TD>2022</TD><TD>2</TD><TD>5</TD><TD>May</TD><TD>19</TD><TD>No</TD></TR></TBODY></TABLE><P>&nbsp;</P> Mon, 30 May 2022 12:19:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547778#M72001 Burak83_ 2022-05-30T12:19:25Z Re: COUNTIFS SUMIFS Power Pivot https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547891#M72009 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="395448" data-lia-user-login="Burak83_" class="lia-mention lia-mention-user">Burak83_</a>&nbsp;Check out the COUNTIF equivalents here:&nbsp;<A href="https://community.powerbi.com/t5/Community-Blog/CO-CU-Excel-to-DAX-Translation/ba-p/1080018#M2077" target="_blank">(1) CO-CU Excel to DAX Translation - Microsoft Power BI Community</A></P> Mon, 30 May 2022 13:07:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547891#M72009 Greg_Deckler 2022-05-30T13:07:57Z Re: COUNTIFS SUMIFS Power Pivot https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547901#M72010 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="395448" data-lia-user-login="Burak83_" class="lia-mention lia-mention-user">Burak83_</a>&nbsp;<BR />Please refer to sample file with the solution&nbsp;<A href="https://www.dropbox.com/t/S2iOGgF60q6tRzxL" target="_blank">https://www.dropbox.com/t/S2iOGgF60q6tRzxL</A></P><P><img /></P><LI-CODE lang="javascript">Cause (Calculated) = VAR CaseYearTable = CALCULATETABLE ( Incidents, ALLEXCEPT ( Incidents, Incidents[Department],Incidents[Description], Incidents[Year] ) ) VAR AnnualOccurrences = COUNTROWS ( CaseYearTable ) VAR TotalLostHours = Incidents[Lost hours] RETURN IF ( AnnualOccurrences &gt;= 4 || TotalLostHours &gt;= 8, "Yes", "No" )</LI-CODE> Mon, 30 May 2022 13:15:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547901#M72010 tamerj1 2022-05-30T13:15:29Z Re: COUNTIFS SUMIFS Power Pivot https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547919#M72011 <P>Hi TamerJ&nbsp;</P><P>Thanks for the solution this is exactly what I have asked for!! I have tried to solve this problem only with countrows or countx but it did not help me. I see that it requires extensive programming!</P> Mon, 30 May 2022 13:30:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547919#M72011 Burak83_ 2022-05-30T13:30:43Z Re: COUNTIFS SUMIFS Power Pivot https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547922#M72012 <P>Hi Greg,</P><P>Thanks for the link!</P> Mon, 30 May 2022 13:31:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-SUMIFS-Power-Pivot/m-p/2547922#M72012 Burak83_ 2022-05-30T13:31:18Z