Forum Discussion

NoordenNL076's avatar
NoordenNL076
Regular Visitor
4 years ago
Solved

Count with exceptions

Hello,   I'm trying to determine the count of a storage type. The storage type is based on the maximum volume a product has within a certain period. However, before linking the storage type there a...
Need Help
Show and Tell
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi NoordenNL076 

    not sure what exactly is your requirement. However, there are many ways to "countif" using dax. For exsmple

    COUNTROWS ( FILTER ( TableName, TableName[ColumnName] = "Value" ) )

    or

    SUMX. (

    TableName,

    IF ( TableName[ColumnName] = "Value", 1 )

    )

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi NoordenNL076 

not sure what exactly is your requirement. However, there are many ways to "countif" using dax. For exsmple

COUNTROWS ( FILTER ( TableName, TableName[ColumnName] = "Value" ) )

or

SUMX. (

TableName,

IF ( TableName[ColumnName] = "Value", 1 )

)