Getting data from one table to another table

Power BI
1

Hi All,

I do not know if this the right forum to ask the question. I am a newbie in Power BI and I am learning.
I have a problem and I am not able to get my head around even after trying for a long time. So, I hope to get answer from the community.

I have two table: Table 1 and Table 2.

Table 1 consist of monthly data and has column like, store number, store name, sales rep, manager, brand and product. It is the data where transaction has oocured in that month.

Table 2 gives the information of all the store present in the company. It is like a master data. It consist of information such as store number, store name, manager, sales rep and active status.

I created a data model using Table 1 where the Fact Table is in middle and get connect to the dimension/lookup table created from Table 1 (Fact Table in data model).

Now I have Table 2 and I do not know who to fit this table 2 in my data model.

My goal:

  1. Count number of store active in Table 2.
  2. Find the store number in Table 2 that are present in Table 1 and count them. I want to do this for each brand. I will provide a slicer for end user.

The link to the pbix file is

Thank you for your help and suggestion.

3

Just reading through your explanation, the first thing that I think of, is that table 2 should be the store dimension table, that way all you need to do for point 1 is calculate countrows (assuming theres no duplicartes in table 2) of Store Key where Status = Active.

For point 2 you could try something similar using calculate countrows of table 2 using a summarise as a filter table using tabe1 as the starting table and summarising the column Store Key, so that table2 will be filtered for stores in table1

I havent tried it, but thats the first thought I had.

4

Hello @wwunsch

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

5

Hi @wwunsch

Due to inactivity, we’d like to conclude that you no longer require assistance to solve your inquiry.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.