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
rocky09's avatar
rocky09
Solution Sage
7 years ago

try this:

 

Create a table like below:

 

Summarized Customres = SUMMARIZE(TransactionInformation,TransactionInformation[CustomerNumber],"Customer_Count",COUNT(TransactionInformation[CustomerNumber]))

Now, make relationships as below:

 

 

Now, Use Customer_count from summary table as Slicer values.

 

 

 

 

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.