Forum Discussion

Rafal_Kosz's avatar
Rafal_Kosz
New Member
6 years ago

Countax with multiple filter

Hello,

 

I have dax function, it is looks like this:

Name = COUNTAX (

FILTER(

     table,

     table.[Field]=Filter 1 &&

     table.[Field]=Filter 2

)

,RelatedTableWithData.Data1 = RelatedTableWithData.Data1

)

And i dont understand why  = RelatedTableWithData.Data1 was use. What is the purpose of this Validation. 

 

Thx a lot for help

 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago
    Because someone didn't know what they were doing? I don't know, that's an odd construct since it will always be true. Not sure why they wouldn't have just gone with COUNTROWS in this circumstance instead of COUNTAX and the extra logical statement.