Countrows with 2 measures from different tables

[tracytran91]

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= 
              COUNTROWS(
                        SUMMARIZE(
                        F_Sales,
                        D_Date[No Month],
                        D_Client[Client Name],
                        D_Customer[Customer]
                        ,"Sales",SUM(F_Sales[Sales])
                        ,"Target",SUM(F_Target[target])
                        ))

Could anyone please help me to solve it?

Much appreciate your help. 

[v-janeyg-msft]

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

[amitchandak]

@tracytran91 , Try a measure like

countrows(F_sales,D_date[Month], D_customer[Customer], C_Client[Client Name] ,"_1" , sum(f_sales[sales]), "_2", sum(F_target[target]))

[tracytran91]

@amitchandak Thank for your suggestion. 

However, it does not work out.