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()) )
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 |