The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Below is the 2 tables
1) AdjusterHierarchy Table
2) ClaimRoot Table (fact). type 2
When we pull adjuster Field against 3PointDays total for ClaimRootEffectDateID as 09/03/2008
it should show details only or
ABC as 51
EDF as 60
But I am not able get that instead I am getting BCD as 29 too which is not right.
Kindly help pls
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |