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
Super User
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())
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k 

It did not work, counts 0. 

 

What could it be ?