Need Help with Dax

[Archiv_Internet]

Hi,

         I have a table as below sample, I would like to get or count the Order Numbers ( the highlighted ones) were only Product A AND Product B have values in them and I would like to ignore the other Order Numbers were there is only one value in either of them

[Anonymous]

Hi @Archiv_Internet ,

Please refer to my pbix file to see if it helps you.

value = CALCULATE(MAX('Table'[order number]),FILTER(ALL('Table'),'Table'[A]<>BLANK()&&'Table'[B]<>BLANK()&&'Table'[order number]=SELECTEDVALUE('Table'[order number])))

Then filter the measure is not blank.

If it still does not help, please provide more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Archiv_Internet]

Hi, I tried it but I have 2 Tables connected by a product key, so Table 1 has the Order No/ProductKey and Table 2 has the Products A and B. So I am not able to refer a single table as it is in your example.

[Anonymous]

Hi @Archiv_Internet , 

Could you please provide your pbix file without privacy information and desired output with more details.

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[daXtreme]

[measure] =
CALCULATE(
    COUNTROWS( T ), // T - your table
    KEEPFILTERS( NOT( ISBLANK( T[Product A] ) ) ), 
    KEEPFILTERS( NOT( ISBLANK( T[Product B] ) ) )
)