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.
Hello,
Can you please support me how to add the green column in the example below, starting from table A & B:
The expected column should contain the total number of companies by class.
Thanks and BR.
Solved! Go to Solution.
@Anonymous , if table A can act as a master table means has a unique company id. Join to on company Id. Else create common dimension of company and calss and analyze data count(TableB[Class]) againt the common dimesnions
Hi @Anonymous ,
You can create a relationship between Table A and Table B on "Company ID" column.
Then on a table visual, move P.Line, Class and COUNT(Company ID).
You will get the desired result.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @Anonymous ,
You can create a relationship between Table A and Table B on "Company ID" column.
Then on a table visual, move P.Line, Class and COUNT(Company ID).
You will get the desired result.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
@Anonymous , if table A can act as a master table means has a unique company id. Join to on company Id. Else create common dimension of company and calss and analyze data count(TableB[Class]) againt the common dimesnions
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |