Forum Discussion
How to count the specific text from another table?
Hello ,
1: make a relationship between the 2 tables : table 1 should be unique as ( product should not be duplicated ) , table 2 it should have Product column ( this can me duplicated as much as you want ) , the relationship shoul go 1 to many
2 : in report view just make a table and drop the product from the first table in the columns ( dont sumarize it ) , and product from the table 2 and set it as count
this is an aproach to make a table
second approach :
in table 1 that is unique make a new calculated column as per the image attached :
count = countrows(relatedtable(table 2 ))
Please accept as a solution if it works with you and a kudo is appreciated .
* share some sample file if you didnt figure it out
Thanks ,
Hi bhelou , thank you for your reply. I tried in power query but the split is not what I want. What I want is just split the Product A, B, C and D into each row:
I can't find the attached file button so below is my table data:
| Product |
| Product A(from USA) |
| Product C(from UAE) |
| Product A(from USA) Product B(from Japan) |
| Product C(from UAE) Product D(from Germany) |
| Product A(from USA) Product B(from Japan) Product D(from Germany) |
| Product A(from USA) Product B(from Japan) Product C(from UAE) |
| Product A(from USA) |
| Product C(from UAE) |
| Product A(from USA) |
| Product C(from UAE) |
| Product D(from Germany) |
| Product D(from Germany) |
Dear Attached Image for the final resulet also attached PBIX file see the steps how to achieve your target .
https://drive.google.com/file/d/1OoAFeSam3SNQ6cEUW4AWmmJC7DQo5AgA/view?usp=sharing
Kindly accept as a solution and a kudo would be greatfull .
Thanks ,Thank you bhelou , I will try later on my personal laptop since google drive is forbidden with our policy. Just quick question: do I have to re-do again all these steps in power query if the data is updated with many records in future?
Hello ,
Its will work automatik everytime there is a refresh from the system .
for any inquiries kindly contact me through my email
[email protected]
Thanks ,