COUNTROWS of multiple tables in one measure

[johnf]

Hi,

I have four tables I require a count of all the rows as one measure.

As I am required to use a Direct Query connection I can't create a helper table to join on.

Anyway I can do this effectively?

Thanks,

John.

[donsvensen · Accepted solution]

Hi

You can create a measure like this

CR = COUNTROWS(Table1)+COUNTROWS(Table2)+COUNTROWS(Table3)+COUNTROWS(Table4)

br

Erik

[tdailey77]

I need to count about 6 more "filters", but I can't get it to work. the only way I get #'s is using just one filter.  

Shows = CALCULATE(COUNTROWS('2018 Opportunity') , FILTER('2018 Opportunity','2018 Opportunity'[Appointment Result] = "Loss - No Sale"))

I want to add "Medical Referral" and about 5 more filters.  Please help.

Thanks!

[tdailey77]

I need to count about 6 more "filters", but I can't get it to work. the only way I get #'s is using just one filter.  

Shows = CALCULATE(COUNTROWS('2018 Opportunity') , FILTER('2018 Opportunity','2018 Opportunity'[Appointment Result] = "Loss - No Sale"))

I want to add "Medical Referral" and about 5 more filters.  Please help.

Thanks!

[johnf]

Thanks for that.

Sometimes I get lost in overthinking the problem 🙂