There are associations between the Class ID in the load editior and also the NAME ID. This doesnt cause any sort of error when loaded. so nothing should be wrong in the data set up.
I have a measure i am trying to create which counts distinctly the number of 'NAME ID' that are integral depending on the school filtered.
So for example....in the dashboard...if i filter on ABC school - the count should reflect: 2
however what i find is the number will reflect 3 (taking into account JP for the other school)
How do i create this measure so that it is specific to the School filtered.
@nickmarlboroughI have a measure I am trying to create which counts distinctly the number of 'NAME ID' that are integral depending on the school filtered.
Does this integral means column present in the table? If yes then you can use Integral column as a flag in set analysis of Qlik Expression
