Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |