The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |