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())
)
tex628's avatar
tex628
Community Champion
7 years ago

I would advice you to create a calculated column, to classify if the reference appears in one ore more techs. 
It should output: 
.NET
Angular 
Both
This should mean a distinct count on .NET/Angular should return the references that only have a single tech. Adding the distinct count of Both should give you the total without any duplicates. 

Hope this helps ! 

Br,
J