Attempting to run cost comparison based on two slicers

[JTMurphy_MaSU]

Morning all,

I'm trying to compare costs at 4 different universities based on the number of credits taken (either 12-15) and what state they are from. Right now I can't figure out how to only get one tuition level (based on State) into the visual (it shows all of them, regardless of what state I choose). All this info is taken from the various school websites, so I can share the file

https://ndusbpos-my.sharepoint.com/:u:/g/personal/john_t_murphy_ndus_edu/ERUQXnOoMIBAnSPhj2U6G5UBO8c...

[JTMurphy_MaSU]

Hi Arul,

I made the pbix file available at the URL below. Also, with your screenshot for Dickinson State, both tuition levels are still being included. There should only be one tuition level to appear (which is determined by the State slicer and the State table. Thanks!

John M.

https://ndusbpos-my.sharepoint.com/:u:/g/personal/john_t_murphy_ndus_edu/ERUQXnOoMIBAnSPhj2U6G5UBO8c...

[Arul]

@JTMurphy_MaSU ,

Please make your table  filtering direction as the below. Then, check if is working or not.

1. Institutions<->States (Both)
2. Institutions<->Rates (Both)

Thanks,

Arul

[JTMurphy_MaSU]

Hi Arul,

Thanks for responding - unfortunately no, it didn't help, it's still showing all the tuition levels regardless of what state I select. Here's a more specific example: 

If a student was from AZ and taking 12 credits:

Mayville State = Tuition Level 4 (4788.96) + Fees (776.76) + Room (1619) + Board (2685)

Valley City State = Tuition Level 3 (4136.55) + Fees (919.56) + Room (1272) + Board (2149)

Dickinson State = Tuition Level 1 (2988) + Fees (824.16) + Room (1500) + Board (2370)

This is what I want to ultimately show. I'm fine with redoing my data tables if that needs to happen. Thanks!

John M.

[Arul]

@JTMurphy_MaSU ,

I am not sure about your underlying data but I can get below output after making some changes in the data model. If you could share your source data that would help.

Thanks,

Arul