title: Marked Items in Horizontal Chart matching with created details visualization
body: <p>I have a horizontal bar contains top 25 defect rate and also created a details visualization using cross table. When i marked the top 1 the details like model and qty populate and shown in cross table. My requirements is to count/sum all records with marked and unmarked and use as multiplier to the qty to get the d rate the cross table. </p>
  
  <p>I try this approached dynamically Sum(case  when [XXX]="XXX" then 1 end) OVER (All([Axis.Rows])) as [Overall Total] but the result is the total qty that are marked are the one displayed or captured. Is there any idea on how to do this using over function or other approached. Thank you in advance. </p>
  
  <p><a href="https://i.stack.imgur.com/5C5Ae.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5C5Ae.jpg" alt="Sample Main and Details Visualization"></a></p>