Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |