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
There is, the measure I wrote.
How is the measure I wrote not what you want? If you want to count the number of times throughput is below the average throughput for the selected time period, that's what my measure does.
Sorry, I'm not following how I haven't provided the answer you asked for.
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