Selected value from table gets changed on selection

Question

Hi all,In my model I have 6 tables. All contain information about Clients and revenue. There is a main table with all clients and the others contain a subset of the main clients broken down into 5 categories (clients may overlap in tables). Each one of the five tables connects to the main table via the client name. I have created 6 table visuals to present the information and I have created a few measures that should be calculated in all tables but the columns used should be changed based on the visual we are in. For this I have created another table with only five rows which I use as a filter on this visual (selecting each time the table name) to indicate in a switch expression which column to select. So all of my measure look like thisRevenue = &nbsp;SWITCH(&nbsp; &nbsp; SELECTEDVALUE(TablePresented[Value]),&nbsp; &nbsp; "Main",&nbsp; &nbsp; SUM(MainTable[Revenue]),&nbsp; &nbsp; "Product1",&nbsp; &nbsp; SUM(Product1[Revenue]),&nbsp; &nbsp; "Product2",&nbsp; &nbsp; SUM(Product2[Revenue]),&nbsp; &nbsp; "Product3",&nbsp; &nbsp; SUM(Product3[Revenue]),&nbsp; &nbsp; "Product4",&nbsp; &nbsp; SUM(Product4[Revenue]),&nbsp; &nbsp; "Product5",&nbsp; &nbsp; SUM(Product5[Revenue]))This works fine until I click on a visual to filter the others for the selected client. Then the measure only gets calculated for the selected table and on the others they appear blank. I run a test with a card visual to get what happens to "TablePresented[Value]" if I set it as a filter on visual and it seems like the table returns me blank value since it gets filter to the selected table on each own and stops being the selected value.Do you have any idea why this happens and whether I could fix it?

kedar_pande · Answer

When you filter by a client, the measure evaluates only the selected table and returns blank for others, as the filter context from TablePresented[Value] conflicts with the other visuals.&nbsp;Update your measure as follows:Revenue =SWITCH(TRUE(),ISFILTERED(MainTable[Client Name]), SUM(MainTable[Revenue]),ISFILTERED(Product1[Client Name]), SUM(Product1[Revenue]),ISFILTERED(Product2[Client Name]), SUM(Product2[Revenue]),ISFILTERED(Product3[Client Name]), SUM(Product3[Revenue]),ISFILTERED(Product4[Client Name]), SUM(Product4[Revenue]),ISFILTERED(Product5[Client Name]), SUM(Product5[Revenue]),BLANK())&nbsp;This approach ensures client selections work correctly for all visuals, avoiding blanks.&nbsp;Your Kudos/Likes are much appreciated!If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.Regards,Kedar Pandewww.linkedin.com/in/kedar-pande

fotfly · Answer

Thank you for you answer.&nbsp;With this approach I have the same client filtered in all tables presenting the total revenue value from the main table when it should be calculating the specific product revenue based on the column selected. That means that each time the MainTable[Client] column is filtered and I get wrong results.

Forum Discussion

Related content

Change in category selection changes selected subcategory in slicers

Selected slicer

Drive / change slicer selection based on value selected from a matrix

Parameter selection for charts

Slicer default selection