Try creating the field [Calculation]:
[Sheet1 (survey raw data_test_4)].[Score]/ COUNTD([Question ID])
Then remove [Calculation1] from your measure values list and replace it with [Calculation]. Is this what you wanted?
Hi Stephen, thanks for answering, but it is not working. in the mean time I had to work with LOD and it seems to work out.
nevertheless the fact that I am trying to do all the scoring calculation in Tableau is really a problem as I am using two data sources and the LOD from the helper file.
I had to change my approach and I am back to doing the scoring in excel, it works better and can aggregate values too..
Find working with LOD just way to complicated for simple users as me..