Forum Discussion
Simple Average
Hello! I have been using an AVERAGEX formula in power bi; however, I am noticing that this formula doesn’t work with breakdowns by category. I want to be able to take the average and divide it y total...
Hello!
I have a measure in power bi that has the % breakdown for a particular category and after I get that I am attempting to create an average. This average however is excluding the months without values. Is there a way to get Power BI to include those months with no values? In the below example I am expecting to see 19.07 or close to that.
It may require a date_dim tbl that I didnt create in the file I am sharing but wanted to give an example quickly.
I have a measure in power bi that has the % breakdown for a particular category and after I get that I am attempting to create an average. This average however is excluding the months without values. Is there a way to get Power BI to include those months with no values? In the below example I am expecting to see 19.07 or close to that.
It may require a date_dim tbl that I didnt create in the file I am sharing but wanted to give an example quickly.
I want the average to be a straight divide by the months so in this case it would be a straight divide by 12. It wouldn’t be 19.06 in this example it would be less. But if I selected on Jan-Oct it would be 19.06 or close to it. I need the calculation to do a straight average divided by each month. If we are looking at only Jan, Feb & March for instance and I select a filter for those months I would expect the average to be 13.06%.