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 )
    )