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 can you share how your data is in powerbi, i don't want o redo the work you alredy did.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry, works like a charm now ! Apologies, I was just missing something in one of my filters! Your solution worked.

Cheers!

Kind Regards,

Nelson 

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous awesome good to hear. cheers!!