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,
I need a dax expression for following situation.
Duration Table:
Process Ref Duration
545454 25
545454 54
217544 25
545454 24
and so on...
Another table with unique process ref number
Process ref table
Process Ref Col1 Average
545454 XX (Averae of particular process ref durations from duration table)
542187 XX (Averae of particular process ref durations from duration table)
217544 XX (Averae of particular process ref durations from duration table)
844541 XX (Averae of particular process ref durations from duration table)
and so on...
I tried the following expression which doesnot turns out.
Average of duartion column =
CALCULATE (
AVERAGE ( Duration table[Duration] ),
Duration table[Process ref] = Process ref table[Process ref]
)
My code returns only error. Any help would be appreciated.
Thanks in advance.
Solved! Go to Solution.
-- If there is a many-to-one relationship -- between 'Duration Table' and 'Process ref -- table', then: [Average of Duration] = CALCULATE ( AVERAGE ( 'Duration Table'[Duration] ) ) -- If the cardinality of the Process ref -- table is huge, in the range of tens -- of thousands and up, then the above -- will be slow because it has to execute -- a context transition. You can also -- use the following in this case: [Average of Duration] = var __currentProcess = 'Process ref table'[Process ref] var __average = AVERAGEX( FILTER( 'Duration Table'[Duration], 'Duration Table'[Process ref] = __currentProcess ), 'Duration Table'[Duration] )
Best
Darek
-- If there is a many-to-one relationship -- between 'Duration Table' and 'Process ref -- table', then: [Average of Duration] = CALCULATE ( AVERAGE ( 'Duration Table'[Duration] ) ) -- If the cardinality of the Process ref -- table is huge, in the range of tens -- of thousands and up, then the above -- will be slow because it has to execute -- a context transition. You can also -- use the following in this case: [Average of Duration] = var __currentProcess = 'Process ref table'[Process ref] var __average = AVERAGEX( FILTER( 'Duration Table'[Duration], 'Duration Table'[Process ref] = __currentProcess ), 'Duration Table'[Duration] )
Best
Darek
@Anonymous ,
Your earlier support for tremendous. Kindly support in this case.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |