I need Help to filter 3 tables in COUNTROWS

[deniselias]

I need help to know how to filter 3 tables in the CALCULATE function to display COUNTROWS of 3 columns with different information.

1 Status Amostra = CALCULATE(COUNTROWS('PO Manual','PO Manual - Andamento','SHeet' - I'),FILTERS('PO Manual'[STATUS FATURA]),FILTERS('PO Manual - Andamento'[STATUS FATURA]))

Tables and columns:

1: 2: 3:

@amitchandak 

[Anonymous · Accepted solution]

Hi @deniselias ,

I created a sample pbix file(see attachment), please check whether that is what you want.

Table = 
UNION (
    SUMMARIZE (
        'PO Manual',
        'PO Manual'[STATUS FATURA],
        "Status Amostra", CALCULATE ( COUNT ( 'PO Manual'[STATUS FATURA] ) )
    ),
    SUMMARIZE (
        'PO Manual - Andamento',
        'PO Manual - Andamento'[STATUS FATURA],
        "Status Amostra", CALCULATE ( COUNT ( 'PO Manual - Andamento'[STATUS FATURA] ) )
    ),
    SUMMARIZE (
        'SHeet',
        'SHeet'[STATUS FATURA],
        "Status Amostra", CALCULATE ( COUNT ( 'SHeet'[STATUS FATURA] ) )
    )
)

If the above one is not what you want, please provide some sample data in 3 tables and your expected result with specific examples. Please also provide the relationship setting among these tables if there is any relationship. Thank you.

Best Regards

[deniselias]

Thanks Yingyinr,

I love your solution!

I also managed to apply the expression:

But your solution made me create another table and I love it!

Thaks, bye!

[deniselias]

Thanks for the answer @selimovd 

I want to make a formula where I can bring information from 3 tables and make a different count for each situation.

Look at the shapes I tried:

And that was the best way. But data from 2 tables is still missing. I want to include it in COUNTA:

I hope you understand.

Thanks!

[selimovd]

Hey @deniselias ,

how is the relationship between these 3 tables?

Where is the final table coming from? When you want a count from 3 other tables, how should that exactly work? Does it depend on a specific column, is the count from one single table?

Please explain a little more, we don't know your data, so it's hard to help you when you don't give much information.

Best regards

Denis

[selimovd]

Hey @deniselias ,

what exactly do you want to do?

The formula doesn't make any sense and I didn't really understand the descriptiont.

Thank you and best regards

Denis

[deniselias]

I want to make a formula where I can bring information from 3 tables and make a different count for each situation.

Look at the shapes I tried:

And that was the best way. But data from 2 tables is still missing. I want to include it in COUNTA:

I hope you understand.

Thanks!