Forum Discussion

Frequent Visitor

3 years ago

Need Help with Dax

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 t...

Anonymous

Not applicable

3 years ago

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.

Need Help with Dax.pbix25 KB

Archiv_Internet

Frequent Visitor

3 years ago

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
Not applicable
3 years ago
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.