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
Download PBIX file with the example below
This works for me
Count Below Average = CALCULATE(COUNTROWS('DataTable'), 'DataTable'[Value] < AVERAGE('DataTable'[Value]))
Regards
Phil
Thanks PhilipTreacy , I am counting events as line items, not an actual value, how would you suggest i do this?
Throughput =CALCULATE(COUNTA('Item'[ItemId]))Not sure what you mean. Please provide an example.
COUNTA counts cells in Excel that aren't empty. If you aren't using actual values, how can you work out an average?
Regards
Phil
I am using date and time slicers to filter the data on the page, each item counted is an event from the sql which i count for throughput. I calculate throughput -
db Throughput = CALCULATE(COUNTA('Item'[ItemId]))
Hope this helps & thanks again
