Forum Discussion
Average Line for Line and Stack Chart
So the issue is with Average function not able to pick up the measure of:
AVERAGE ( 'Incidental Findings Note'[Incidental Findings Note Type Compliance] )
Here is the error: The AVERAGE function only accepts a column reference as an argument.
The breakdown of the measures are as below:
Incidental Findings Note Type Compliance = [Sum of Discharge Patients w Note Type IF]/[Sum of Incidental Findings MRN]
Sum of Discharge Patients w Note Type IF = CALCULATE(COUNT('Distinct MRN for Incident Findings Note Type'[MRN]), 'Distinct MRN for Incident Findings Note Type'[Incidental Both] = 1)
Sum of Incidental Findings MRN = DISTINCTCOUNT('Table1 (2)'[MRN])
I have tried AVERAGEX to capture the measure and still could not get the correct average. Let me know if that helps. I will try to provide a sample pbix file. The issue is private health information data in the file.