cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AdrianaReyna Frequent Visitor
Frequent Visitor

Filter table based on some values of another table

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.

 

5.JPG

 

This is the link for pbi

 

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

 

 

Thanks for the help.

4 REPLIES 4
Highlighted
AdrianaReyna Frequent Visitor
Frequent Visitor

filter one table by some values of other table

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.
Community Support Team
Community Support Team

Re: Filter table based on some values of another table

Hi @AdrianaReyna,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
AdrianaReyna Frequent Visitor
Frequent Visitor

Re: Filter table based on some values of another table

HI @v-shex-msft

 

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

Community Support Team
Community Support Team

Re: Filter table based on some values of another table

HI @AdrianaReyna,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |