Forum Discussion

phamtrinh96's avatar
phamtrinh96
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper II
7 years ago

When I chose the number of Customer, only the change in the 1st chart, but there was no change in the 2nd chart according to the 1st chart.

And I thing this problem is not easy , But we often encounter this problem because the powerbi does not support the filter in Measure.

  • rocky09's avatar
    rocky09
    Icon for Solution Sage rankSolution 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
      Icon for Helper II rankHelper II
      7 years ago

      Yes , 

      Expect Result when I Choose 1

      And Expect Result When I Choose 2

      Thanks you 

      • rocky09's avatar
        rocky09
        Icon for Solution Sage rankSolution 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.