Forum Discussion
Solved
PBI Line chart counting numbers below average
Hi all, and thanks in advance. Hoping someone can assist me, I need a measure to count items on a line chart that are below average as below.
Download PBIX file with the example below
This works for me
Count Below Average = CALCULATE(COUNTROWS('DataTable'), 'DataTable'[Value] < AVERAGE('DataTable'[Value]))Regards
Phil
You have too many closing square brackets and parentheses. Try this
db Count Below Average = CALCULATE(COUNTROWS('Item'), 'Item'[ItemId] < AVERAGE('Item'[ItemId]))
Regards
Phil