Forum Discussion
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...
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()) )
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())
)
Anonymous cannot tell why without looking at data. if you can share data using excel and remove any sensitive inforamtion, it will help
As you can see there is one Reference that contain both technologies.
This is directly extracted from the excel. "Other Techno" column has been shaped in Power BI, so I have one line per technology in my data model. Makes Sense?
Thank you!
Reference Other Techno CALx00499 RPG, Sentinel, RDJ, APACHE, TIBCO CALx00889 RPG CALx00882 RPG, HTML CALx00056 RPG, Shell scripts, JIRA, CALx01494 RPG CALx01971 RPG CALx01301 NATURAL, RPG, ADABAS CALx02021 Adélia, RPG, HP Alm (Application Lifecycle Management) CALx01415 RPG, SAP, Outsystems CALx02051 RPG CALx00398 RPG CALx02018 PL/SQL, RPG CALx00804 RPG