Count Distinct Across Two tables works until I try and add a filter...

[Anonymous]

Hi

I have written a measure which allows me to countdistinct across two tables as follows;

JM TEST =

COUNTROWS (

    INTERSECT (

        VALUES ( 'Product List'[ProdID]),

        DISTINCT (

            UNION (

                VALUES ( 'Product List'[ProdID ),

                VALUES (Item List [Prod ID] )

            )

        )

    )

)

However, when I try and filter, I get an error message saying Function INTERSET does not support joining a column of type Integer with a column type of Text.

Any idea on what is going wrong or how I can add multiple filters to the measure?

Thanks

[Dangar332]

hi, @Anonymous 

hey joseph one of your column (Product List'[ProdID ) or (Item List [Prod ID] ) is text type so check it change it to interger or wholenumber

[Anonymous]

Hi

I have checked and they are text but they need to be text, how would I change this to allow me to filter on text?

[Dangar332]

hi, @Anonymous 

if you want  in text ffilter then change your Integer column to text

make your both columns ('Product List'[ProdID] ,List [Prod ID] ) to text form