Forum Discussion
Solved
Fetching values from cross tables in power bi
Scenario: Relationships: H 1:N HBD H 1:N TM HBD 1:N PR BR 1:N PR BR 1:N TH Table created on PR where we are showing name of records of H In one column and we need to show the ...
HI subhashis29,
Perhaps you can try to write a measure expression to use the relationship keys as variable to extract the BR table records and use these key lists to filter table records to get the second level table(PR) relationship keys. After repeating these steps, you will get the key fields list of the HBD table as conditions to calculate.
Regards,
Xiaoxin Sheng
HI subhashis29,
Perhaps you can try to write a measure expression to use the relationship keys as variable to extract the BR table records and use these key lists to filter table records to get the second level table(PR) relationship keys. After repeating these steps, you will get the key fields list of the HBD table as conditions to calculate.
Regards,
Xiaoxin Sheng