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= 
              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. 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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]))

  • 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