many to many different granularity

[powerbiexpert22]

i do not see correct target quantities

[TomMartens · Accepted solution]

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

[TomMartens · Accepted solution]

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

[powerbiexpert22 · Accepted solution]

thanks @TomMartens  for detailed feedback

[powerbiexpert22]

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

[powerbiexpert22]

Hi @TomMartens 

PBIX File: 

https://drive.google.com/file/d/19jN7PY7idDImWl2y4DFhjnUJCc2qIg15/view?usp=sharing

Sample Data:

https://docs.google.com/spreadsheets/d/1YoAuzaq9M8RW0T7wYhiN75fI79QRNYL0/edit?usp=sharing&ouid=10701...

Expected Output:

[TomMartens]

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

[TomMartens]

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