topic Re: Filter auto the detail table by the names in the table of totals (SUM() of the detail values) in Developer

Filter auto the detail table by the names in the table of totals (SUM() of the detail values)

rberchtoldp — Mon, 24 Oct 2022 15:38:56 GMT

Hi Community,

¿Do you know if there is a way whenever table 2 is filtered through the filter of 1 by some Total Value (this is a SUM () metric), the users that appear in that table are those that are owed show in table 3 without having to click on any name in table 2?

In the case of the screen, the AGR Table shows the name blank and Benjamin but the detailed table show more names that this two.

If i click for example in Bejamin, the detail table shows all the detail information of Benjamin only but i need all the detailed information about all the names filtered in the AGG Table without to have to select a row in the AGG table.

I don't know if with power bi is possible to do it.

Best Regrds

Re: Filter auto the detail table by the names in the table of totals (SUM() of the detail values)

Anonymous — Tue, 25 Oct 2022 02:56:53 GMT

Hi @rberchtoldp ,

It is hard to say that it is possible or not to achieve it due to there is no sample data and model tables information. Does any relationshop exist in these three tables? I need to understand why the detailed table show more names that this two? Could you please provide the above required info? Thank you.

Best Regards

Re: Filter auto the detail table by the names in the table of totals (SUM() of the detail values)

rberchtoldp — Tue, 25 Oct 2022 07:01:59 GMT

Hello yingyinr and thanks very much for your response,

I generated a sample dataset by i don't know how i can upload here.

The sample dataset only contains one table with this data.

This is the report without any filter.

And if we select the table object "Table with Totals" and set higer than 100 in SUM of value filter, this object "Table with Totals" is well filtered showing Jose and Juan but, the "Table with Detail by day" continue containing all the detail data of all Name. We want that when "Table of Totals" is filtered by Suma de Value de Table with Detail by day is filtered too containing only de datailed data of the names showed in the "Table with Totals".

¿Do you know how is possible do it ?

Thanks in advance,

Best Regards.

Re: Filter auto the detail table by the names in the table of totals (SUM() of the detail values)

Anonymous — Tue, 25 Oct 2022 07:42:39 GMT

Hi @rberchtoldp ,

As checked the screenshots you shared, it seems that you apply a visual-level filter on the main table visual. This filter WILL NOT effect the below detail table visual definitely. You can create a calculated column as below to get the sum of value per name first, and apply a page-level filter on these table visuals just as below screenshot. Please find the details in the attachment.

Sum of value = CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )

Create a calculated column to get the sum of value per name

Apply a page-level filter to filter the data which sum of value greater than 100

Best Regards