Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multiple filters counta

Hello, I 've been trying to solve this measure for a while. Every help is appreciated.  Data table has different values in Sufix template. Those values are connected with load number and I want to r...
  • ValtteriN's avatar
    4 years ago

    Hi,

    Here is one way to do this:

    Data:


    Dax:

    LoadNumbertest = if(countrows(
    FILTER(LoadNumber,
    LoadNumber[LoadNumber]=MAX(LoadNumber[LoadNumber])
    &&LoadNumber[Code]="A3"
    ||LoadNumber[Code]="VCG"))>1,1,0)
     
    End result:

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!