Display the values selected by the slicer in the table.

[Lopez0090]

There is a report that uses a table like the one in the image.
Parameter table is a date table created by what-if.

The "Text date" is a text type date column that can be used to search for dates.

As shown in the image, I am able to create a table visual and display the values selected in "Text date", but the values in the "Area" column of Table2 are displayed in all the rows and cannot be displayed as expected.

note: "Parameter value (= measure)" has not been changed since it was automatically created.

Parameter value = SELECTEDVALUE('Parameter'[Parameter])

This is an sample, but this is how I would like it to appear in practice.

If any of you have any good ideas, please let me know.

[v-xiaotang]

Hi @Lopez0090 

Sorry for the late reply. The file you shared has been deleted, could you share again? 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Lopez0090]

@v-xiaotang 

I'm sorry. I've re-shared the file.

Best regards,

Lopez

https://d.kuku.lu/797481a8b

[v-xiaotang]

Hi @Lopez0090 

thanks for your reply.

I think the current result in your sample file is right, the values in the "Area" column of Table2 are displayed as expected now.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Lopez0090]

@v-xiaotang 

Thanks for looking at the sample files.

Now I am using the "RELATED" function to get the Area of Table2.

As you said, it works fine if you use the Area column of Table1 created using Related.

However, in reality, there are a number of tables like Table2.

So I am considering if it is possible to do this without adding any columns to Table1, just measures (As more columns are added, performance is affected...).

Is it possible to achieve this with just a measure?

Best Regards,

Lopez

[v-xiaotang · Accepted solution]

Hi @Lopez0090 

Because you have a one-to-many relationship between Parameter and Table1, so it is reasonable that table1 is filtered according to the date you choose.

But in your expected result, you want the selected date to appear in all rows of table1, which violates the filter logic. Personally speaking, since there is no relationship between the selected value and table1 & table2, so the desktop cannot decide which row to assign it to. 

In summary, if you want to get the expected results, there must be a specific connection.

By the way, it's also not possible to achieve this with measure, because there is only one row in your table after you select date in slicer, so only this row can get Area,

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Lopez0090 , I think data is repeating because of Area, You need to take and Min or Max. If I got the issue correctly?

[Lopez0090]

@amitchandak 

Sorry, which value do I need to take from ?

[amitchandak]

@Lopez0090 , First table Area repeating and second has min of that ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Lopez0090]

@amitchandak 

Thank you.

The URL to download the sample file is provided below.

https://d.kuku.lu/2ce93bff2