Filter table based on some values of another table

[Anonymous]

Hello all! I have this situation, I hope someone could help me!

I have two tables, that are not related and canot be, when I click on one of them, I want to look in the other for the field HKONE, WRBTR, Date, etc.

I found and example and I can achieve search with one column; with this Measure:

HKONE2 = COUNTROWS(FILTER('Sheet1',SEARCH('Sheet1'[HKONE],MAX('Table'[HKONE]),,0)>0)) then I put the measure HKONE2 in visual filters and show the value when is greater than 0; and works ok.

But what I want is to have two or more columns like HKONE and bring me the information of the table, for example that I can display in the details table when the HKONE and the WRBTR are equal to the ones selected in the table (Sheet1).

For example:

I selected in the first table  the first row with 11301000 and in the second table show me all the rows with the same number 11301000; I want to show the rows with 11301000 and the WRBTR 0.32 two, and then with the same Date 01/09/2011, etc.

This is the link for pbi

https://drive.google.com/file/d/1vsiWEDCOOhSNkxrFBZmZ-UbjTU-WcnrA/view?usp=sharing

Thanks for the help.

[Anonymous]

Hello all! I have this question, I hope someone could help me! I have two tables, that are not related and canot be, when I click on one of them, I want to look in the other for the field HKONE, WRBTR, Date, etc. I found and example and I can achieve search with one column; with this Measure: HKONE2 = COUNTROWS(FILTER('Sheet1',SEARCH('Sheet1'[HKONE],MAX('Table'[HKONE]),,0)>0)) then I put the measure HKONE2 in visual filters and show the value when is greater than 0; and works ok. But what I want is to have two or more columns like HKONE and bring me the information of the table, for example that I can display in the details table when the HKONE and the WRBTR are equal to the ones selected in the table (Sheet1). For example: I selected in the first table the first row with 11301000 and in the second table show me all the rows with the same number 11301000; I want to show the rows with 11301000 and the WRBTR 0.32 two, and then with the same Date 01/09/2011, etc. This is the link for pbi https://drive.google.com/file/d/1vsiWEDCOOhSNkxrFBZmZ-UbjTU-WcnrA/view?usp=sharing Thanks for the help.

[Anonymous]

Hi @Anonymous,

Current power bi not support to create dynamic calculated column/table based on slicer/filter.

You can create a dynamic measure based on slicer, but if you use it in a calculated column, it will been fixed and only return static value.

Regards,

Xiaoxin Sheng

[Anonymous]

HI @Anonymous

Thanks for the reply.

nor can you filter a table with another table, taking two columns as a reference?
For example in this case with the HKONE and the WBTR

Thanks

[Anonymous]

HI @Anonymous,

It is possible to use other table static columns as reference in measure or calculated column calculation.  If you want that column is dynamic based on filter or slicer, it only works on measure calculation.

Regards,

Xiaoxin Sheng