Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey @powerbiexpert22 ,
the relationship between the ProductDim and TagetFact is NOT active (this is why it's a dotted line that is viusalizing the relationship):
If you change this, you will see this in the table visual immediately:
Be aware that the Clothing data is not 40 because of the typo
Clothing vs
Cothing
in the TagetFact table.
Regards,
Tom
Hey @powerbiexpert22 ,
the relationship between the ProductDim and TagetFact is NOT active (this is why it's a dotted line that is viusalizing the relationship):
If you change this, you will see this in the table visual immediately:
Be aware that the Clothing data is not 40 because of the typo
Clothing vs
Cothing
in the TagetFact table.
Regards,
Tom
Hi @TomMartens ,
I am still getting same results , I have uploaded the updated file ActualvsTargetv1.pbix in same folder in google drive
https://drive.google.com/file/d/1iqraL-ubK0sfRrq_H5s5RWhmrZQ4fW1w/view?usp=sharing
Hey @powerbiexpert22 ,
the only missing part is a relationship between the tables ProductDim and TagetFact. The next screenshot shows the model after I created this relationship:
Because the targets are on the category level a many-to-many is required, this is also the reason I chose
"Single (ProductDim filters TagetFact)", make sure the relationship is active:
There is also a small typo in the data of the TagetFact table; once, it says Clothing, and the second, it says Cothing (the l is missing).
Hopefully, this provides what you are looking for.
Regards,
Tom
Hey @powerbiexpert22 ,
consider creating a pbix file containing sample data that still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix file to OneDrive, Google Drive, or dropbox and share the link. Do not forget describe the expected result based on your sample data.
Regards,
Tom
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |