I added DAX to calculate average of counts for 6 months data in Matrix visual of power Bi. Instead of calculating for the total count average, the DAX is calculating average for each month and added extra columns in my visual. How can i remove those extra columns and display only one total count of average column for 6 months data.

I want to add a column in the power bi matrix visual to calculate the average of the sum of columns. the column displays the count of items. please assist.

This is my data model for PBI.

I have to analyse the time each member of our IT group spends on solving Tickets. While the first column displays the total for each member on all Categories (this is the one I get correctly), the next columns should display the total of time each member spent on the different Categories.

I want to calculate an average of a column after modifying it with a multiplication.
This means that I want to calculate the average of:

Create a new measure, Cumulative Inventory, based on Sale In (SI) and Sale Out (SO) columns:
For January 2023, Cumulative Inventory = 0 (starting month for inventory calculation).
For months after January 2023, Cumulative Inventory = Previous month’s Cumulative Inventory + Previous month’s SI – Pre

I have a table that contains the daily roster for each staff

I have two tables connected together by date. I want to create a calculation which will calculate the earlies and the latest date per customer.

I am struggling to get the current file name in the Power BI report.
I tried the following solutions:

I’m doing your standard Sales analysis (think AdventureWorks DW), but the twist I’m dealing with is that each of my Products has a recipe (ProductKey, IngredientKey, Weight), but the Ingredient is a slowly changing dimension (because the price changes over time). The “recipe” table is static.