Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Tables and columns:
1: 2: 3:
Solved! Go to 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
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
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!
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!
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
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |