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
can you provide an example :
Suppose, if you select number 2 from the slicer, what are the results you want to see in the Table 1 and Table 2?

phamtrinh96's avatar
phamtrinh96
Helper II
7 years ago

Yes , 

Expect Result when I Choose 1

And Expect Result When I Choose 2

Thanks you 

  • 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.