Hello guys, I am displaying a Matrix visual in Power BI that shows me a specific value for business units. Business UnitCost11,00022,00031,50042,500Total7,000 The Cost Value in the visual contains a measure which looks something like this:Cost =CALCULATE( SUM(table1[values]), FILTER(table2, table2[header] = "costs"), FILTER(table3, NOT(table3[business_units] = "2222")) I want to add a slicer visual to be able to select a specific date so the matrix visual shows the values for the date i select in the slicer. Now I also want to add a Card visual that shows me the Average of the [Cost] measure values depending on the dates I selected in the slicer. For example: If I select Jan 2020, Feb 2020 and March 2020 the card visual shows the Average [Cost] for the selected months.If I select Jan - Dec 2020 the card visual shows the Average of the whole 12 months in the year. How do I write a measure to give me such an interactive Average? Thank you

OK, you'll need to replace Table[Business Unit] with year and month columns from your date table. Avg per Month =AVERAGEX(SUMMARIZECOLUMNS(Date[Year], Date[Month],"@Cost", [Cost]),[@Cost])

Measure for Average displayed in Card Visual

Forum Discussion

Related content

DAX Measure for Ranking the valid rows and calculating the average rating

Rolling 12M Average measure

Average of measure

Weighted Average Measure

Average of average measure