https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Flag-column-for-detecting-payment-in-category-with-other/m-p/1963077#M42991 <P>The wording of the problem is hardly comprehensible (that's why you've received no answers yet). Can you please explain this in a clear fashion so that people can understand it and help you? Thanks. Before you do it, please get familiar with this:&nbsp;<A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener">https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490</A></P><P>&nbsp;</P><P>By the way, a calculated column can never respond to a slicer/filter. Ever.</P> Fri, 16 Jul 2021 21:58:48 GMT Anonymous 2021-07-16T21:58:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Flag-column-for-detecting-payment-in-category-with-other/m-p/1961481#M42905 <P>Hello everyone!</P><P>I already broke my brain with a simple task.</P><P>&nbsp;</P><P>I have transactions table with customer_id, service, transactions and dates.</P><P>I need to make a calculated column that should display if a customer pay some service by selected filters and calculate count of a customers with flag Y or N (payed or not)</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>&nbsp;</TD><TD>Day 1</TD><TD>Day 2</TD><TD>Day 3</TD><TD>Day 4</TD></TR><TR><TD>Is payed P2P service = Y</TD><TD>100</TD><TD>56</TD><TD>3</TD><TD>23</TD></TR><TR><TD>Is payed P2P service = N</TD><TD>10</TD><TD>15</TD><TD>18</TD><TD>28</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>My idea is make a simple tool to investigate crosssales over services.</P><P>&nbsp;</P> Fri, 16 Jul 2021 08:03:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Flag-column-for-detecting-payment-in-category-with-other/m-p/1961481#M42905 Portmone 2021-07-16T08:03:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Flag-column-for-detecting-payment-in-category-with-other/m-p/1963077#M42991 <P>The wording of the problem is hardly comprehensible (that's why you've received no answers yet). Can you please explain this in a clear fashion so that people can understand it and help you? Thanks. Before you do it, please get familiar with this:&nbsp;<A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener">https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490</A></P><P>&nbsp;</P><P>By the way, a calculated column can never respond to a slicer/filter. Ever.</P> Fri, 16 Jul 2021 21:58:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Flag-column-for-detecting-payment-in-category-with-other/m-p/1963077#M42991 Anonymous 2021-07-16T21:58:48Z