Fetching values from cross tables in power bi

[subhashis29]

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 count of records of TM for that particular huddle in the same table.

How can we show that?

We have brought t hame of table H by expanding the column HBD on PR and then by expanding H.

[Anonymous · Accepted solution]

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