Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two tables, the first shows the products and their ratio. The second shows the product and their values. I wish to create a new column to calculate the converted value (value/ratio) according to the respective product category. I tried to make a one-to-many relationship from first table to second table by linking 'product'. However, it only allows many-to-many relationship and both direction. How to make it one-to-many relationship and single direction? Any help given is appreciated. Thank you.
First table:
Second table:
Expected output:
Solved! Go to Solution.
Hi:
I beleive answer is same (actually provide Calc Col and Measure). The main thing was to answer the relationship question. Please see attached for that part. I hope this helps..
https://drive.google.com/file/d/1n_q1I9SuwHTEZXTSTQDFjQnX39uG0BXl/view?usp=sharing
Hi:
I beleive answer is same (actually provide Calc Col and Measure). The main thing was to answer the relationship question. Please see attached for that part. I hope this helps..
https://drive.google.com/file/d/1n_q1I9SuwHTEZXTSTQDFjQnX39uG0BXl/view?usp=sharing
Did you manually type in the Prod_ID column in the Data table?
Hi @Anonymous .
You can create a summary table using "SUMMARIZE'.
You can write your DAX as ;
Thanks,
Sanket
If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.
sry but I am not sure why the table 1 does not show up in the summarize function
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |