https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-Distinct-Count-not-working/m-p/3290950#M7686 <P>Hey&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/575888">@PRFInstitute</a>&nbsp;</P><P>Try Plotting below Measure which calculated distinct count in pie chart.<BR />MeasureUniqueCount = DISTINCTCOUNT(YourColumnName).<BR /><BR /><EM><STRONG>If it worked for you please accept this reply as solution!</STRONG></EM>&nbsp;</P> Mon, 19 Jun 2023 12:27:15 GMT Dhairya 2023-06-19T12:27:15Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-Distinct-Count-not-working/m-p/3285631#M7674 <P>Hi, I've a Pie chart on my dashboard in Power BI. The Pie chart is based on the column that inlcudes duplicates. I have a card on my dashboard that shows me the number of distinct values in that column &amp; also the total number values (no. of rows in excel). When I select "Count" the pie chart works well but when I select "Distinct Count", I expect the Pie chart to change values on only have the unique distinct in it. However, when totalling the numbers of the slices.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Power BI.PNG" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/928968i22BA9AD5AA2D0CF2/image-size/large?v=v2&amp;px=999" role="button" title="Power BI.PNG" alt="Power BI.PNG" /></span></P> Thu, 15 Jun 2023 09:42:07 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-Distinct-Count-not-working/m-p/3285631#M7674 PRFInstitute 2023-06-15T09:42:07Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-Distinct-Count-not-working/m-p/3290950#M7686 <P>Hey&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/575888">@PRFInstitute</a>&nbsp;</P><P>Try Plotting below Measure which calculated distinct count in pie chart.<BR />MeasureUniqueCount = DISTINCTCOUNT(YourColumnName).<BR /><BR /><EM><STRONG>If it worked for you please accept this reply as solution!</STRONG></EM>&nbsp;</P> Mon, 19 Jun 2023 12:27:15 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-Distinct-Count-not-working/m-p/3290950#M7686 Dhairya 2023-06-19T12:27:15Z