topic Distinct count duplicated by legend - filter value prioritization in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2809391#M88819 <P>Hello,<BR />I have a below table:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Transaction ID</TD><TD>Customer ID</TD><TD>Customer Type</TD><TD>Created On</TD><TD>Alerted?</TD></TR><TR><TD>1</TD><TD>1</TD><TD>CUSTOMER</TD><TD>01.01.2022</TD><TD>Not Alerted</TD></TR><TR><TD>2</TD><TD>1</TD><TD>CUSTOMER</TD><TD>01.02.2022</TD><TD>Not Alerted</TD></TR><TR><TD>3</TD><TD>1</TD><TD>VENDOR</TD><TD>01.03.2022</TD><TD>Alerted</TD></TR><TR><TD>4</TD><TD>1</TD><TD>BANK</TD><TD>01.04.2022</TD><TD>Not Alerted</TD></TR><TR><TD>5</TD><TD>1</TD><TD>VENDOR</TD><TD>01.05.2022</TD><TD>Alerted</TD></TR><TR><TD>6</TD><TD>2</TD><TD>VENDOR</TD><TD>01.01.2022</TD><TD>Not Alerted</TD></TR><TR><TD>7</TD><TD>2</TD><TD>VENDOR</TD><TD>01.02.2022</TD><TD>Not Alerted</TD></TR><TR><TD>8</TD><TD>2</TD><TD>BANK</TD><TD>01.03.2022</TD><TD>Not Alerted</TD></TR><TR><TD>9</TD><TD>2</TD><TD>BANK</TD><TD>01.04.2022</TD><TD>Not Alerted</TD></TR><TR><TD>10</TD><TD>2</TD><TD>BANK</TD><TD>01.05.2022</TD><TD>Alerted</TD></TR><TR><TD>11</TD><TD>2</TD><TD>BANK</TD><TD>01.06.2022</TD><TD>Not Alerted</TD></TR><TR><TD>12</TD><TD>2</TD><TD>BANK</TD><TD>01.07.2022</TD><TD>Not Alerted</TD></TR><TR><TD>13</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.08.2022</TD><TD>Not Alerted</TD></TR><TR><TD>14</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.09.2022</TD><TD>Not Alerted</TD></TR><TR><TD>15</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.10.2022</TD><TD>Not Alerted</TD></TR><TR><TD>16</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.11.2022</TD><TD>Not Alerted</TD></TR><TR><TD>17</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.12.2022</TD><TD>Not Alerted</TD></TR><TR><TD>18</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.01.2022</TD><TD>Not Alerted</TD></TR><TR><TD>19</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.02.2022</TD><TD>Not Alerted</TD></TR><TR><TD>20</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.03.2022</TD><TD>Not Alerted</TD></TR><TR><TD>21</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.04.2022</TD><TD>Not Alerted</TD></TR><TR><TD>22</TD><TD>3</TD><TD>VENDOR</TD><TD>01.05.2022</TD><TD>Not Alerted</TD></TR><TR><TD>23</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.01.2022</TD><TD>Not Alerted</TD></TR><TR><TD>24</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.02.2022</TD><TD>Not Alerted</TD></TR><TR><TD>25</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.03.2022</TD><TD>Not Alerted</TD></TR><TR><TD>26</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.04.2022</TD><TD>Not Alerted</TD></TR><TR><TD>27</TD><TD>3</TD><TD>BANK</TD><TD>01.05.2022</TD><TD>Alerted</TD></TR><TR><TD>28</TD><TD>3</TD><TD>VENDOR</TD><TD>01.06.2022</TD><TD>Not Alerted</TD></TR><TR><TD>29</TD><TD>3</TD><TD>VENDOR</TD><TD>01.07.2022</TD><TD>Not Alerted</TD></TR><TR><TD>30</TD><TD>3</TD><TD>VENDOR</TD><TD>01.08.2022</TD><TD>Not Alerted</TD></TR><TR><TD>31</TD><TD>3</TD><TD>VENDOR</TD><TD>01.09.2022</TD><TD>Not Alerted</TD></TR><TR><TD>32</TD><TD>3</TD><TD>VENDOR</TD><TD>01.10.2022</TD><TD>Not Alerted</TD></TR><TR><TD>33</TD><TD>3</TD><TD>VENDOR</TD><TD>01.11.2022</TD><TD>Not Alerted</TD></TR><TR><TD>34</TD><TD>3</TD><TD>VENDOR</TD><TD>01.12.2022</TD><TD>Not Alerted</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>It contains unique [Transaction ID], but the Business Partner ([Customer ID]) can appear multiple times - also each Business Partner can have many roles: customer, vendor or bank.<BR />Each Transaction is validated and can receive an Alert (column: [Alerted?]).<BR />Creating visual with transactions status (Alerted vs. Not Alerted) was easy, but I can't figure out how to show on pie chart business partners with their status. Each Business Partner should be able to be filtered by [Customer Type] and [Created On] date.<BR />Without the specific measure the visual shows duplicated distinct count (as each Business Partner is Alerted for some transactions, but also has status 'Not Alerted' for other transactions.<BR /><BR />Do you know what measure could solve this issue? If the Business Partner for selected slicers would have 'Alerted' status - it should only appear as 'Alerted' and not as 'Not Alerted'. Currently the visual shows duplicates (which is a standard behavior for distinct count with applied legend.<BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>I'd be very grateful if you'll help me with solving that.<BR /><BR />Cheers,<BR />Anna</P> Sat, 01 Oct 2022 17:39:07 GMT TepStep 2022-10-01T17:39:07Z Distinct count duplicated by legend - filter value prioritization https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2809391#M88819 <P>Hello,<BR />I have a below table:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Transaction ID</TD><TD>Customer ID</TD><TD>Customer Type</TD><TD>Created On</TD><TD>Alerted?</TD></TR><TR><TD>1</TD><TD>1</TD><TD>CUSTOMER</TD><TD>01.01.2022</TD><TD>Not Alerted</TD></TR><TR><TD>2</TD><TD>1</TD><TD>CUSTOMER</TD><TD>01.02.2022</TD><TD>Not Alerted</TD></TR><TR><TD>3</TD><TD>1</TD><TD>VENDOR</TD><TD>01.03.2022</TD><TD>Alerted</TD></TR><TR><TD>4</TD><TD>1</TD><TD>BANK</TD><TD>01.04.2022</TD><TD>Not Alerted</TD></TR><TR><TD>5</TD><TD>1</TD><TD>VENDOR</TD><TD>01.05.2022</TD><TD>Alerted</TD></TR><TR><TD>6</TD><TD>2</TD><TD>VENDOR</TD><TD>01.01.2022</TD><TD>Not Alerted</TD></TR><TR><TD>7</TD><TD>2</TD><TD>VENDOR</TD><TD>01.02.2022</TD><TD>Not Alerted</TD></TR><TR><TD>8</TD><TD>2</TD><TD>BANK</TD><TD>01.03.2022</TD><TD>Not Alerted</TD></TR><TR><TD>9</TD><TD>2</TD><TD>BANK</TD><TD>01.04.2022</TD><TD>Not Alerted</TD></TR><TR><TD>10</TD><TD>2</TD><TD>BANK</TD><TD>01.05.2022</TD><TD>Alerted</TD></TR><TR><TD>11</TD><TD>2</TD><TD>BANK</TD><TD>01.06.2022</TD><TD>Not Alerted</TD></TR><TR><TD>12</TD><TD>2</TD><TD>BANK</TD><TD>01.07.2022</TD><TD>Not Alerted</TD></TR><TR><TD>13</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.08.2022</TD><TD>Not Alerted</TD></TR><TR><TD>14</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.09.2022</TD><TD>Not Alerted</TD></TR><TR><TD>15</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.10.2022</TD><TD>Not Alerted</TD></TR><TR><TD>16</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.11.2022</TD><TD>Not Alerted</TD></TR><TR><TD>17</TD><TD>2</TD><TD>CUSTOMER</TD><TD>01.12.2022</TD><TD>Not Alerted</TD></TR><TR><TD>18</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.01.2022</TD><TD>Not Alerted</TD></TR><TR><TD>19</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.02.2022</TD><TD>Not Alerted</TD></TR><TR><TD>20</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.03.2022</TD><TD>Not Alerted</TD></TR><TR><TD>21</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.04.2022</TD><TD>Not Alerted</TD></TR><TR><TD>22</TD><TD>3</TD><TD>VENDOR</TD><TD>01.05.2022</TD><TD>Not Alerted</TD></TR><TR><TD>23</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.01.2022</TD><TD>Not Alerted</TD></TR><TR><TD>24</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.02.2022</TD><TD>Not Alerted</TD></TR><TR><TD>25</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.03.2022</TD><TD>Not Alerted</TD></TR><TR><TD>26</TD><TD>3</TD><TD>CUSTOMER</TD><TD>01.04.2022</TD><TD>Not Alerted</TD></TR><TR><TD>27</TD><TD>3</TD><TD>BANK</TD><TD>01.05.2022</TD><TD>Alerted</TD></TR><TR><TD>28</TD><TD>3</TD><TD>VENDOR</TD><TD>01.06.2022</TD><TD>Not Alerted</TD></TR><TR><TD>29</TD><TD>3</TD><TD>VENDOR</TD><TD>01.07.2022</TD><TD>Not Alerted</TD></TR><TR><TD>30</TD><TD>3</TD><TD>VENDOR</TD><TD>01.08.2022</TD><TD>Not Alerted</TD></TR><TR><TD>31</TD><TD>3</TD><TD>VENDOR</TD><TD>01.09.2022</TD><TD>Not Alerted</TD></TR><TR><TD>32</TD><TD>3</TD><TD>VENDOR</TD><TD>01.10.2022</TD><TD>Not Alerted</TD></TR><TR><TD>33</TD><TD>3</TD><TD>VENDOR</TD><TD>01.11.2022</TD><TD>Not Alerted</TD></TR><TR><TD>34</TD><TD>3</TD><TD>VENDOR</TD><TD>01.12.2022</TD><TD>Not Alerted</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>It contains unique [Transaction ID], but the Business Partner ([Customer ID]) can appear multiple times - also each Business Partner can have many roles: customer, vendor or bank.<BR />Each Transaction is validated and can receive an Alert (column: [Alerted?]).<BR />Creating visual with transactions status (Alerted vs. Not Alerted) was easy, but I can't figure out how to show on pie chart business partners with their status. Each Business Partner should be able to be filtered by [Customer Type] and [Created On] date.<BR />Without the specific measure the visual shows duplicated distinct count (as each Business Partner is Alerted for some transactions, but also has status 'Not Alerted' for other transactions.<BR /><BR />Do you know what measure could solve this issue? If the Business Partner for selected slicers would have 'Alerted' status - it should only appear as 'Alerted' and not as 'Not Alerted'. Currently the visual shows duplicates (which is a standard behavior for distinct count with applied legend.<BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>I'd be very grateful if you'll help me with solving that.<BR /><BR />Cheers,<BR />Anna</P> Sat, 01 Oct 2022 17:39:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2809391#M88819 TepStep 2022-10-01T17:39:07Z Re: Distinct count duplicated by legend - filter value prioritization https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2810054#M88949 <P>Please provide sanitized sample data that fully covers your issue. <BR /><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR /></P> Sat, 01 Oct 2022 13:49:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2810054#M88949 lbendlin 2022-10-01T13:49:49Z Re: Distinct count duplicated by legend - filter value prioritization https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2810234#M88966 <P>Thank you for the message. I've replaced the screenshot of table with actual table copied from spreadsheet.<BR /><BR />Kind Regards,<BR />Anna</P> Sat, 01 Oct 2022 17:40:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2810234#M88966 TepStep 2022-10-01T17:40:37Z Re: Distinct count duplicated by legend - filter value prioritization https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2810330#M88973 <P>see attached for a proposal using two complementary measures.</P> <P>&nbsp;</P> Sat, 01 Oct 2022 20:10:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-count-duplicated-by-legend-filter-value-prioritization/m-p/2810330#M88973 lbendlin 2022-10-01T20:10:21Z