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.
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.
Solved! Go to 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
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
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |