Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Distinct Count

Hi Everyone,    I would like to request your support on the following measure. I need to distinctcount all #Refs that have both Angular and .NET, however, some of those #Refs have both technologie...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous change your measure 

     

    M_Count_Tech_Angular&.NET =                                                           
CALCULATE(DISTINCTCOUNT(Sourcing[Reference]);        
FILTER(Sourcing;Sourcing[Tech]  IN {"Angular", ".NET"});
FILTER(Sourcing; Sourcing[Table1] = "Test");
FILTER(Sourcing; Sourcing[ATT Level] <> BLANK())
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous if they are in both technologies, which technology they will be counted against, angular or net

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi parry2k 

These #Refs are resources, which means that if one engineer has both technologies I only want to count him once. 

What is happening now is that I have 1 person that has both, RPG and Adelia, and this person is being counted 2x.

Is it clear now? 

 

Thank you for your help!