Forum Discussion
Distinct Count
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()) )
Hi parry2k ,
They only need to count once as they only need one to be in the bucket. These Refs are Resources. Which means that if you have 1 person with both technologies, you want to count this person only once.
Is it clear now? Thank you for your help!
Anonymous nope, it didn't answered my question. I understand you want to count the person once, but in your pie chart, under which technology that person will get counted toward?
Oh sorry,
In the green slice. In the example I have Angular and .NET, and I just wrote Adelia and RPG above. But I have multiple pie charts like this one to show technologies against all distinct count #REFS.
Does that make sense now ?
Thank you very much.
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()) )