topic Re: Urgent Help !!!Report view for with condition - Weekly in Power Query https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3610193#M118564 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="652164" data-lia-user-login="619SK" class="lia-mention lia-mention-user">619SK</a>&nbsp;,<BR /><BR />Please try:</P> <LI-CODE lang="markup">Points = VAR _cur_category = SELECTEDVALUE('Table'[Age Category]) VAR _count = [Open Defect Count] VAR _points = CALCULATE(SUM('ConditionTable'[Value]),'ConditionTable'[Attribute]=_cur_category &amp;&amp; 'ConditionTable'[Count of Defect]=_count) + 0 RETURN _points</LI-CODE> <P>And</P> <P><img /></P> <P><FONT size="2">Best Regards,<BR />Gao</FONT><BR /><FONT size="2">Community Support Team</FONT></P> <P>&nbsp;</P> <P><FONT size="2">If there is any post<SPAN>&nbsp;</SPAN><FONT size="3" color="#008080"><EM><STRONG>helps</STRONG></EM></FONT>, then please consider<SPAN>&nbsp;</SPAN><FONT size="3"><FONT color="#008080"><EM><STRONG>Accept it as the solution</STRONG></EM></FONT><SPAN>&nbsp;&nbsp;</SPAN></FONT>to help the other members find it more quickly.<BR />If I misunderstand your needs or you still have problems on it, please feel free to let us know.<SPAN>&nbsp;</SPAN><FONT color="#008080"><EM><STRONG><FONT size="3">Thanks a lot!</FONT></STRONG></EM></FONT></FONT></P> <P><FONT size="2" color="#FF0000"><A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener nofollow noreferrer"><SPAN>How to get your questions answered quickly</SPAN></A><SPAN>&nbsp;--&nbsp;</SPAN><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank" rel="noopener nofollow noreferrer"><SPAN>&nbsp;</SPAN>How to provide sample data in the Power BI Forum</A>&nbsp;--&nbsp;<A href="https://community.fabric.microsoft.com/t5/China-Power-BI-User-Group/gh-p/ChinaPowerBIUserGroup" target="_blank" rel="noopener">China Power BI User Group</A></FONT></P> Tue, 02 Jan 2024 04:56:09 GMT Anonymous 2024-01-02T04:56:09Z Urgent Help !!!Report view for with condition - Weekly https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3605281#M118365 <P>My task is to add "<STRONG>point</STRONG>" column based upon sample data.&nbsp; have added sample data along with condition.</P><P>1) How to calculate point based upon condition&nbsp; and add in report view with weeks filter</P><P>2) How to show particular Age category count 0 as when i added week filter then it shows only those who are having value</P><P>&nbsp;</P><P>Points are calculated based upon conditions. For example - Age category "&gt;180 days" defect count is 3 &amp; as per condition it should so "0" as point also for "90-180 Days" there is 0 count of defect hence as per condition 100 point.</P><P>1) Outcome view from Bi</P><TABLE border="1"><TBODY><TR><TD>Age Category</TD><TD>Open Defect Count</TD><TD><STRONG>Points</STRONG></TD><TD>RAG</TD></TR><TR><TD>&gt;180 Days</TD><TD>3</TD><TD>0</TD><TD>Red</TD></TR><TR><TD>90-180 Days</TD><TD>0</TD><TD>100</TD><TD>Green</TD></TR><TR><TD>0-15 Days</TD><TD>53</TD><TD>80</TD><TD>Green</TD></TR><TR><TD>15-30 Days</TD><TD>3</TD><TD>100</TD><TD>Green</TD></TR><TR><TD>60-90 Days</TD><TD>0</TD><TD>100</TD><TD>Green</TD></TR><TR><TD>30-60 Days</TD><TD>2</TD><TD>90</TD><TD>Green</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Condition for point calculations</P><P><img /></P><P>&nbsp;</P><P>Sample data</P><TABLE border="1"><TBODY><TR><TD>Start Date</TD><TD>Defect Status</TD><TD>Start of Week</TD><TD>Age</TD><TD>Age Category</TD></TR><TR><TD>16-11-2023</TD><TD>Open</TD><TD>13-11-2023</TD><TD>42</TD><TD>30-60 Days</TD></TR><TR><TD>20-11-2023</TD><TD>Open</TD><TD>20-11-2023</TD><TD>38</TD><TD>30-60 Days</TD></TR><TR><TD>29-11-2023</TD><TD>Open</TD><TD>27-11-2023</TD><TD>29</TD><TD>15-30 Days</TD></TR><TR><TD>07-12-2023</TD><TD>Open</TD><TD>04-12-2023</TD><TD>21</TD><TD>15-30 Days</TD></TR><TR><TD>10-12-2023</TD><TD>Open</TD><TD>04-12-2023</TD><TD>18</TD><TD>15-30 Days</TD></TR><TR><TD>16-12-2023</TD><TD>Open</TD><TD>11-12-2023</TD><TD>12</TD><TD>0-15 Days</TD></TR><TR><TD>18-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>10</TD><TD>0-15 Days</TD></TR><TR><TD>18-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>10</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>19-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>9</TD><TD>0-15 Days</TD></TR><TR><TD>21-12-2023</TD><TD>Open</TD><TD>18-12-2023</TD><TD>7</TD><TD><P>0-15 Days</P></TD></TR></TBODY></TABLE> Thu, 28 Dec 2023 11:34:04 GMT https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3605281#M118365 619SK 2023-12-28T11:34:04Z Re: Urgent Help !!!Report view for with condition - Weekly https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3606486#M118409 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="652164" data-lia-user-login="619SK" class="lia-mention lia-mention-user">619SK</a>&nbsp;,<BR /><BR />Please&nbsp; try:<BR />1. Unpivot these columns:</P> <P><img /></P> <P>2. then please create 2 measures:</P> <LI-CODE lang="markup">Open Defect Count = COUNTROWS('Table')</LI-CODE><LI-CODE lang="markup">Points = VAR _cur_category = SELECTEDVALUE('Table'[Age Category]) VAR _count = [Open Defect Count] VAR _points = CALCULATE(SUM('ConditionTable'[Value]),'ConditionTable'[Attribute]=_cur_category &amp;&amp; 'ConditionTable'[Count of Defect]=_count) RETURN _points</LI-CODE> <P><img /></P> <P>Please check the pbix file.<BR /><BR /></P> <P><FONT size="2">Best Regards,<BR />Gao</FONT><BR /><FONT size="2">Community Support Team</FONT></P> <P>&nbsp;</P> <P><FONT size="2">If there is any post<SPAN>&nbsp;</SPAN><FONT size="3" color="#008080"><EM><STRONG>helps</STRONG></EM></FONT>, then please consider<SPAN>&nbsp;</SPAN><FONT size="3"><FONT color="#008080"><EM><STRONG>Accept it as the solution</STRONG></EM></FONT><SPAN>&nbsp;&nbsp;</SPAN></FONT>to help the other members find it more quickly.<BR />If I misunderstand your needs or you still have problems on it, please feel free to let us know.<SPAN>&nbsp;</SPAN><FONT color="#008080"><EM><STRONG><FONT size="3">Thanks a lot!</FONT></STRONG></EM></FONT></FONT></P> <P><FONT size="2" color="#FF0000"><A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener nofollow noreferrer"><SPAN>How to get your questions answered quickly</SPAN></A><SPAN>&nbsp;--&nbsp;</SPAN><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank" rel="noopener nofollow noreferrer"><SPAN>&nbsp;</SPAN>How to provide sample data in the Power BI Forum</A>&nbsp;--&nbsp;<A href="https://community.fabric.microsoft.com/t5/China-Power-BI-User-Group/gh-p/ChinaPowerBIUserGroup" target="_blank" rel="noopener">China Power BI User Group</A></FONT></P> Fri, 29 Dec 2023 06:10:46 GMT https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3606486#M118409 Anonymous 2023-12-29T06:10:46Z Re: Urgent Help !!!Report view for with condition - Weekly https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3606498#M118410 <P>Thanks&nbsp;Anonymous</a>&nbsp; I will try&nbsp;</P> Fri, 29 Dec 2023 06:25:46 GMT https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3606498#M118410 619SK 2023-12-29T06:25:46Z Re: Urgent Help !!!Report view for with condition - Weekly https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3606569#M118414 <P>If i add Filter with Status (Open/Close) then it shows only Age category which is having values.</P><P>How can i show Age category&nbsp; as 0&nbsp; and Point 100.</P> Fri, 29 Dec 2023 07:22:22 GMT https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3606569#M118414 619SK 2023-12-29T07:22:22Z Re: Urgent Help !!!Report view for with condition - Weekly https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3607093#M118440 <P>Hi,</P> <P>Why should the answer be 80 for 0-15 days and 53?&nbsp; There is no such entry in the Points calculation table.</P> Fri, 29 Dec 2023 12:15:17 GMT https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3607093#M118440 Ashish_Mathur 2023-12-29T12:15:17Z Re: Urgent Help !!!Report view for with condition - Weekly https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3607110#M118442 <P>Hi, 56 is total count of Defect for 0-15 days &amp; 80 is Point as per the condition as its &gt;10</P> Fri, 29 Dec 2023 12:26:31 GMT https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3607110#M118442 619SK 2023-12-29T12:26:31Z Re: Urgent Help !!!Report view for with condition - Weekly https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3610193#M118564 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="652164" data-lia-user-login="619SK" class="lia-mention lia-mention-user">619SK</a>&nbsp;,<BR /><BR />Please try:</P> <LI-CODE lang="markup">Points = VAR _cur_category = SELECTEDVALUE('Table'[Age Category]) VAR _count = [Open Defect Count] VAR _points = CALCULATE(SUM('ConditionTable'[Value]),'ConditionTable'[Attribute]=_cur_category &amp;&amp; 'ConditionTable'[Count of Defect]=_count) + 0 RETURN _points</LI-CODE> <P>And</P> <P><img /></P> <P><FONT size="2">Best Regards,<BR />Gao</FONT><BR /><FONT size="2">Community Support Team</FONT></P> <P>&nbsp;</P> <P><FONT size="2">If there is any post<SPAN>&nbsp;</SPAN><FONT size="3" color="#008080"><EM><STRONG>helps</STRONG></EM></FONT>, then please consider<SPAN>&nbsp;</SPAN><FONT size="3"><FONT color="#008080"><EM><STRONG>Accept it as the solution</STRONG></EM></FONT><SPAN>&nbsp;&nbsp;</SPAN></FONT>to help the other members find it more quickly.<BR />If I misunderstand your needs or you still have problems on it, please feel free to let us know.<SPAN>&nbsp;</SPAN><FONT color="#008080"><EM><STRONG><FONT size="3">Thanks a lot!</FONT></STRONG></EM></FONT></FONT></P> <P><FONT size="2" color="#FF0000"><A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener nofollow noreferrer"><SPAN>How to get your questions answered quickly</SPAN></A><SPAN>&nbsp;--&nbsp;</SPAN><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank" rel="noopener nofollow noreferrer"><SPAN>&nbsp;</SPAN>How to provide sample data in the Power BI Forum</A>&nbsp;--&nbsp;<A href="https://community.fabric.microsoft.com/t5/China-Power-BI-User-Group/gh-p/ChinaPowerBIUserGroup" target="_blank" rel="noopener">China Power BI User Group</A></FONT></P> Tue, 02 Jan 2024 04:56:09 GMT https://community.fabric.microsoft.com/t5/Power-Query/Urgent-Help-Report-view-for-with-condition-Weekly/m-p/3610193#M118564 Anonymous 2024-01-02T04:56:09Z