Second table is filtering data of entire row of first table, instead of data of only one cells value

[Amit_Saxena]

Need your help

I have two tables;

 In Table1, which has summary level segment wise data with all the metrics(used one dimension to represent the metrics, unpivot the data to have all metrics in one column).

In Table 2- I want second table(which has all the records) to only filter the data based on selection in cell values appearing in table 1 but here i could see that my second table shows data of entire row of the table, because filter works on dimension so it's filtering the data based on Segment.

How should i show records in table 2 with data related with specific cell not the entire Row, pls suggest! 

Here for example if I click on cell which has value “P1 Only and Segment is High, which is 1 then in 2nd table it should not reflect the data of column name “Prod_2_Sales”.

Regards,

Amit

[parry2k · Accepted solution]

@Amit_Saxena make sure there is a relationship between these two tables and that will filter table 2 from table1, if this doesn't work, share sample data and expected output.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Amit_Saxena]

Thanks @parry2k for your time, creating another measure which filter the data in table based on Numerator of the calculation in Table1 works!! Thanks for your suggestion!!

[Amit_Saxena]

Hello @parry2k, 
Thanks for your quick response, i am using single table as of now(flat file)

This is how my raw data look like. Herei should be able to see data of records id 1 in 2nd table.

[v-zhenbw-msft]

Hi @Amit_Saxena ,

The P1 Only column is in aggregation state.

When you select P1 Only is 1 and Segment is High, there are two rows will be filtered. Because the P1 only 1 contains 1 and 0.

So if you want to filter one row, you need to configure the P1 only Don’t Summarize.

Then select P1 only equal 1.

If you have any question, please kindly ask here and we will try to resolve it.

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.

[Amit_Saxena]

Thanks for your resonse @ v-zhenbw-msft

This will create two rows in table 1 (by doing segment as don't summarize).

I need to show segment as three records only, also this is dummy data and my actual data in Table1 is based on the calculation of these 1's divided by unique ids, Also while selecting the data for P1 Only valaue table 2should only show the P1 sales value and other sales columns like P2 saes and P3 sales should not appear in table or reflect 0 zero values. 

Cell Click 01.pbix 

How can i share my sample PBI? have tried to attached the sample file.

[v-zhenbw-msft]

Hi @Amit_Saxena ,

You can upload your files to OneDrive For Business and share the link here.

Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

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