Forum Discussion

bprokop's avatar
bprokop
Frequent Visitor
2 years ago
Solved

Table Visualization Display All Customers In A State When A Single Slicer Value Selected

Hi,   I am trying to create a Table that maintains All Customers within the State when a Single Customer is selected in a Slicer.  See example below.  Below I have a SALES and CUSTOMER table and I ...
Need Help
ThxAlot's avatar
ThxAlot
Super User
2 years ago

SMURF.pbix

 

Construct the CUSTOMER dimensional table this way,

 

 

 

  • bprokop's avatar
    bprokop
    Frequent Visitor
    2 years ago

    I see how your solution works with the sample but I am struggling to integrate it into my actual data.  I have attached a link to the actual pbix used.  In the model, I have a Slicer for "Hospital".  I inserted a Table and tried to recreate the Measure used in your example but was unsuccessful.  Measure equivalents in attached model are: Hospital Name = Name, SALES Qty = State Rank Filter and Rank = SUM Sales.  With these calculation when I use the Slicer to filter by a Hospital, the Table will only display the MAX Hospital in the State.  How do I get ALL Hospitals in a State to display when a single Hospital is selected with the Data Set in the pbix attached.  Thanks for your help.

     

    https://drive.google.com/file/d/16g6ooz88UbtQLdZFQvKkObLIUquuK9zN/view?usp=sharing 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

      Please clarify the result that you want to see.  Let's say that you select Good Samaritan Hospital in the slicer.  What exact result do you want to see - show the result in a table.

      • bprokop's avatar
        bprokop
        Frequent Visitor
        2 years ago

        Hi Ashish,

         

        If you select Good Samaritan Hospital and it is located in California, I want the Table to display all Hospitals with the State of California.  Hopefully, that makes sense.  

         

        Brian