Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Intersection Issue in DAX

Hi All,   Since i didnt get proper solution in last post. I m posting another time. I have two columns with name Product Code and Customer Name. I want to calculate the unqiue number of customers ...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
6 years ago

Anonymous 

 

Similarly if you want the list of such customers in a card visual, you can use this MEASURE

 

ListOfCustomers =
VAR myproducts =
    COUNTROWS ( ALLSELECTED ( Table1[ProductCode] ) )
RETURN
    CONCATENATEX (
        FILTER (
            VALUES ( Table1[CustomerCode] ),
            COUNTROWS (
                INTERSECT (
                    ALLSELECTED ( Table1[ProductCode] ),
                    CALCULATETABLE ( VALUES ( Table1[ProductCode] ) )
                )
            ) = myproducts
        ),
        [CustomerCode],
        UNICHAR ( 10 )
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    Zubair_Muhammad 

    I want the list of customers in the Grid only as i have more than 10,000 customers.

    how do i go for it??

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      6 years ago

      Anonymous 

       

      We can do it with another MEASURE and use it as a VISUAL filter.

       

      But is my formula working now?

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

        Zubair_Muhammad 

        Your Formula for Intersection is still not working in my enviorment, though i have calculated some logics in SQL and import that logic as a column and then used my Previous DAX which i have shared and its working. But i m not able to get the Names of Customers based on my DAX. Can you please help me into this??