https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Fix-Relationship-for-Distinct-Count-column-and-row-values/m-p/3871444#M9544 <P>I have a visual that uses a default Dataverse Direct query relationship.<BR />There a three departments from the related table as shown in department slicer.<BR />The main visual does show unique counts of the department of the related table, but the value of ONE of the department row (only it has a value of hrs = 4.00) are duplicated across all rows.<BR />Also all departments are listed as rows with no record counts.<BR /><BR /><STRONG>I need to only show the three Departments in the main visual with counts and total hrs in only the row that has the true total hrs.</STRONG><BR /><BR /></P><P><img /></P><P>&nbsp;</P> Fri, 26 Apr 2024 15:44:13 GMT DuskyLeaf 2024-04-26T15:44:13Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Fix-Relationship-for-Distinct-Count-column-and-row-values/m-p/3871444#M9544 <P>I have a visual that uses a default Dataverse Direct query relationship.<BR />There a three departments from the related table as shown in department slicer.<BR />The main visual does show unique counts of the department of the related table, but the value of ONE of the department row (only it has a value of hrs = 4.00) are duplicated across all rows.<BR />Also all departments are listed as rows with no record counts.<BR /><BR /><STRONG>I need to only show the three Departments in the main visual with counts and total hrs in only the row that has the true total hrs.</STRONG><BR /><BR /></P><P><img /></P><P>&nbsp;</P> Fri, 26 Apr 2024 15:44:13 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Fix-Relationship-for-Distinct-Count-column-and-row-values/m-p/3871444#M9544 DuskyLeaf 2024-04-26T15:44:13Z