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 )

    )

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi NoordenNL076 ,

 

Whether the advice given by tamerj1  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry