Forum Discussion
Same Value Multiple Columns
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 colu...
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
thanks will try, out of curiosity how does this differ from using the count distinct right click option on the field value? Thanks again