Forum Discussion

Archiv_Internet's avatar
Archiv_Internet
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 the other Order Numbers were there is only one value in either of them

 

4 Replies

  • daXtreme's avatar
    daXtreme
    Solution Sage
    3 years ago
    [measure] =
CALCULATE(
    COUNTROWS( T ), // T - your table
    KEEPFILTERS( NOT( ISBLANK( T[Product A] ) ) ), 
    KEEPFILTERS( NOT( ISBLANK( T[Product B] ) ) )
)
  • Anonymous's avatar
    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.

    • Archiv_Internet's avatar
      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's avatar
        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.