Forum Discussion

tracytran91's avatar
tracytran91
Helper III
4 years ago

Countrows with 2 measures from different tables

Hi friends,    I have the model like this:      I would like count number of row of the table which contains:    I created this measure but it does not work out: No_Of_Row= ...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, tracytran91 

 

Although there are relationships between your model tables, the target and sales tables are not related, and the three dimension tables are not related, so your code can't be written like this...

 
Without data it is difficult for us to provide valid code. if you can share some insensitive data samples and expected output, we can help you better.
 
Best Regards,
Community Support Team _ Janey