Forum Discussion

ErikH321's avatar
ErikH321
Regular Visitor
9 years ago
Solved

DAX Measure Question...

Hi,

 

I'm somewhat new with DAX and am having an issue with creating a measure (it is probably easy but it is eluding me).

 

I'm creating a measure that will count the product codes in a column but I want it counted only for 5 of the many values.

 

So, for example, I've tried:  

 

Product Count = Calculate(CountA (Product[type] ), Product[type]=10, Product[type]=12, Product[type]=14 ......

 

This works for the first product type but when I add the additional filters (12,14, etc) the result is blank.  I'm assuming this is acting as an AND or it is looking for diffternt Columns to filter on.  At any rate, what I'm doing is obviously wrong.  I've tried other variations but I'm not finding a solution.

 

Any help would be appreciated!

  • ErikH321

     

    Hi. 

     

    Use || (OR)

     

    Product Count = Calculate(CountA (Product[type] ), Filter(Product[Type],Product[type]=10 || Product[type]=12 || Product[type]=14 ))

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    ErikH321

     

    Hi. 

     

    Use || (OR)

     

    Product Count = Calculate(CountA (Product[type] ), Filter(Product[Type],Product[type]=10 || Product[type]=12 || Product[type]=14 ))