I can't say anything unless I see your data. However, instead of blending, create a duplicate sheet with total value, combine it your dashboard, and don't apply filter on it.
Please check the attached.
Let me know if this helps.
total merge.twbx 1.2 MB
But I have got it now, just to get a total I am using only one data source, As you can see in picture Boreas is category and I have applied filter on Boreas but my total value does not change I used a calculated field
Like: LOOKUP(MIN([Boreas]),0) This will keep my total constant. And named it Calculation1 and put it in filter shelf. and showing same filter on right side.
My Total is nothing but: WNDOW_SUM(SUM(TIQTYP40)) : This is nothing but total parts produced
BoqtysPair: Faulty Parts Produced
But now to get % I am using : sum([BoqtysPair])/ WNDOW_SUM(SUM(TIQTYP40))
But as you can see in last column I am trying to show % but its coming wrong when I do BoqtysPair/Total Parts.
Can you tell what can be going wrong. And my % calculation I am doing Compute using pane down.
What are the expected numbers? Also, please share .twbx file.