Same Value Multiple Columns

[Zanderol24]

Hi, 

Im trying to construct a visual with the below scenario, 

I have a Dynamics Opportunity that features 3 columns with a relatioship to the Dynamics Competitor table, these are lookup columns. 

The lookup coulumn names on the opportunity could be 

Product1

Product2

Product3 

Product4, 

My goal within the visual is to count the values for each column per categort (product)

No matter how I do this the values are always the same across all bi visuals, im not sure how to get the data to calculate how many times an opportinity has had the lookup column on based on the competitor, all values aRE always identical, do i need to use a dax query or am i overlooking something simple

[chonchar]

Try creating a measure and putting it into the values. Make one for each product:

Product one count =
DISTINCTCOUNT(
(Table name)[Product1]
) 
^^ do the same for products 2-4 (four unique measures) then add them to the values pane. 

Good luck and hope this helps,

Cam

[Zanderol24]

thanks will try, out of curiosity how does this differ from using the count distinct right click option on the field value?  Thanks again