Distinct count based on conditions for other columns

[Earl40]

Hello,

Im trying to count only the distinct values in a column called "Order ID" but only when certain criteria is present in other columns, 

 the criteria: count distincy values in Order ID column , only where system column is "OCI" and the type column is "Notification" and origina column is "AB" and the date colum (which shows month and year e.g October 2023) is February 2024. 

Any help would be greatly apreciated

[olgad · Accepted solution]

DistinctOrderCount =
CALCULATE( COUNTROWS( VALUES('YourTable'[Order ID]) ),
'YourTable'[system] = "OCI",
'YourTable'[type] = "Notification",
'YourTable'[original] = "AB",
FORMAT('YourTable'[date_column], "YYYYMM") = "202402" )

[Anonymous · Accepted solution]

Hi @Earl40 ,

First of all, many thanks to @olgad  for your very quick and effective replies, I'll provide a different dax formula below for your reference.

DistinctCountConditional = 
CALCULATE(
    DISTINCTCOUNT('YourTableName'[Order ID]),
    'YourTableName'[system] = "OCI",
    'YourTableName'[type] = "Notification",
    'YourTableName'[origina] = "AB",
    FORMAT('YourTableName'[date], "MMMM YYYY") = "February 2024"
)

Please replace `'YourTableName'` with the actual name of your table.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[olgad · Accepted solution]

DistinctOrderCount =
CALCULATE( COUNTROWS( VALUES('YourTable'[Order ID]) ),
'YourTable'[system] = "OCI",
'YourTable'[type] = "Notification",
'YourTable'[original] = "AB",
FORMAT('YourTable'[date_column], "YYYYMM") = "202402" )