Forum Discussion

phamtrinh96's avatar
phamtrinh96
Helper II
7 years ago

[ Show in Table Chart ]

Hi Everyone ,  I have a problem. I create two table chart , One table chart show customer information and " Number Of Transaction " of Customer .  Ex :    One table chart show transaction in...
Need Help
phamtrinh96's avatar
phamtrinh96
Helper II
7 years ago

I'm sorry , I missing Restaurant slicer , It use to choose Restaurant. 

If we choose a specific restaurant, "Number Of Customer" will change, so we need to use measure.

So this solution doesn't sure.

Due to my confuse , I'm sorry , Pls help me again.

file powerbi in this links updated https://drive.google.com/file/d/1KUUSG-oeQMGdLPp7MyTiD4Wfs7SpPqnQ/view?usp=sharing

Result expect when I choose RestaurantCode = RC2 and NumberOfCustomer  = 3

rocky09's avatar
rocky09
Solution Sage
7 years ago

ok.

create another table for restaurant code like below:

Restaurant = DISTINCT(TransactionInformation[RestaurantCode])

Now, create relationship like this.

 

 

 

and drag and drop fields from the tables like below.

 

 

  • phamtrinh96's avatar
    phamtrinh96
    Helper II
    7 years ago

    No ,if choose RestaurantCode = RC4 and NumberCustomer = 1 then True Result is

    I want ask , Why aren't you use measure same me ?  

  • rocky09's avatar
    rocky09
    Solution Sage
    7 years ago
    Even one works differently for the same results.

    May be someone will help you.. All the best.
  • phamtrinh96's avatar
    phamtrinh96
    Helper II
    7 years ago

    Thanks for your help, 

    Can you give me some people to contact and ask?

  • rocky09's avatar
    rocky09
    Solution Sage
    7 years ago

    that was the basic Idea. If you have proper data model. It will be easier way to achieve. Wait for Community Official Support team to help you.