'How to create Power BI datamodel
I have 3 tables:
A: Columns (a,b,c,d) B: Columns (a,c,f) C: Columns (f,c,h,k)
I could able to create a merge column between a+c , f+C and join tables. Purpose is to get count of A(b) by A(d) and C(k).
Visual shows counts by A(d) fine but drill down into C(k) shows same counts on all bars. what is the mistake? Is it in joins? Model shows relation as 1:1 between these tables. Table B and C are related, Tables A and B are related but table A has no direct relation with table C, is this the issue?
Please enlighten.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|