Forum Discussion
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 return a number of rows which include both values like A3 and VCG.
In case load number has both values then returned value shoul be 1.
I have tried many calculation but none return a correct value.
Here is last calulation i tried:
Thank you
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!
2 Replies
- ValtteriN
Community Champion
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!