Average score of active items

[Pbiuserr]

Hello,

I have a report where business choose period, lets say they choose 08.2022
For this period, I've got lets say 1000 items active and all of them got some score (1-10). What I would like to do, is to get average score of active items per period

[SpartaBI]

@Pbiuserr if you just write a simple AVERAGE('Table'[score]) you will get the right result when putting it on a chart / matrix breaking down by months and having a filter for true on the active index column.

You can also write somehing like:
CALCULATE(AVERAGE('Table'[score], 'Table'[status] = 'Active') 
and then you don't need to use a visual filter context for this measure.

Showcase Report – Contoso By SpartaBI



      

[Pbiuserr]

Hi,

For the chart I am aware of. Its for the card. My initial thinking was just to do AVERAGE (column), but I guess its more save if it meets criteria thats its active. To indicate active (CountOfActive, its not unfrotunately the status, but the flag must be 1 and item_prd = 0, so the measure would be :

CALCULATE (AVERAGE (Table[Score], ITEM_PRD = 0, ITEM_FLG = 1) ?

[SpartaBI · Accepted solution]

@Pbiuserr yep just with proper column names: 'Table'[column] = value

You could also just put these filters in the visual level filters, but I like better the approach of creating a dedicated measure like our 1st option.

Showcase Report – Contoso By SpartaBI