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 

 

Try this MEASURE

 

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

HI Zubair_Muhammad 

 

I' m getting values by selecting individual ProductCode but getting Blank values if i do Multiselect on ProductCode.

Can you suggest for this one?

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    6 years ago

    Hi Anonymous 

     

    I am attaching the pbix file with your sample data

     

    I get correct figures as you mentioned.

    Please take a look and let me know

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

      Zubair_Muhammad 

      Still not working  in my pbix file. 

      Momemt i multi-select itemcode, it gives me blank values. However it is working in yours. I m not able to understand .

      Please suggest something??

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        6 years ago

        Anonymous 

         

        You can share your file with me if you like.

        Are you using some VISUAL or PAGE level filters?