Help Need: Average count of Month along with criteria

[Enan]

Hi Experts,

I am using below measure to count the yesterday values based on the required criteria (Filter) which is working fine.

TC = CALCULATE (COUNT (FACT_noav[Date]),

FILTER(FACT_noav,FACT_noav[Rank]<>"CK"),FACT_noav[Date]-TODAY()-1,

FACT_noav(Main_Cat]="Sickness"

||FACT_noav[Main Cat]="Locp"

||FACT_noav[Main_Cat]-"Others"

||FACT_noav[Main_Cat]="SIDL"

Now i have additional requirment and i want to calculate the Average Monthly count based on the above criteria which in used in above measure.

Below data model for information.

Appreciate your guidance.

[Ashish_Mathur]

Hi,

Share some data, explain the question and show the expected result.

[adudani]

hi @Enan ,

try this
var existingoutput = IF( isblank(TC),0,TC)

var _avgmonthly =
Averagex( Values (DateTable[MonthColumn]),
existingoutput
)
return

_avgmonthly

essentially, wrap the measure in averagex over the values of the month, and calulcate the expression you need.

reference: (12) Calculate Average Per Day / Month / Year In Power BI Using DAX - YouTube

if this doesn't resolve the issue, please share sample input data removing sensitive information