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.
Hi All,
We're trying to create a seemingly simple calculation between two tables to measure the risk score for quality issues.
In 'table1' I have a [Keywords] field and a [Phase Value] field that have reference values that relate the phase at which an issue is discovered to a numeric value.
In 'table2' I have a list of issues that each have a corresponding [Keywords] value and a [Severity] value.
My goal is for each issue to multiply the [Severity] value from 'table2' with the [Phase Value] from 'table1'.
Any help would be greatly appreciated!
Solved! Go to Solution.
Hi @jrhughes,
In your 'phases' table, the values of "Keywords" field are unique, right? If it is, you can create relationship between 'Current' table and 'phases' table. Then please create a calculated column using RELATED function. I try to reproduce your scenario as follows.
My sample data tables.
Create calculated column using the formula below, and get expected result shown in screenshot.
IssueScore = 'Current'[Severity]*RELATED(Phases[Phase Value])
If you have any issue, please feel free to ask.
Best Regards,
Angelia
Hi @jrhughes,
In your 'phases' table, the values of "Keywords" field are unique, right? If it is, you can create relationship between 'Current' table and 'phases' table. Then please create a calculated column using RELATED function. I try to reproduce your scenario as follows.
My sample data tables.
Create calculated column using the formula below, and get expected result shown in screenshot.
IssueScore = 'Current'[Severity]*RELATED(Phases[Phase Value])
If you have any issue, please feel free to ask.
Best Regards,
Angelia
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |