Current Reporting Month To be shown in Card

Ok. Here is a pbix file that has your example data. I created two measures and a calculated column and ended up with the values you are looking for.

 

Hi Anonymous ,

I think this happens because you have data from multiple years.

The following DAX expression does not take the year into consideration, the maximum month is 6, and the data for 2023 and 2024 are calculated.

The Table data is shown below:

Use the following DAX expression to create a measure

Measure = 
VAR _summarizeTable = ADDCOLUMNS(SUMMARIZE('Table','Table'[Txn Dt],"average",AVERAGE('Table'[New Adoption])),"month",MONTH([Txn Dt]),"year",YEAR([Txn Dt]))
VAR _maxMonthNumber = MONTH(MAX('Table'[Txn Dt]))
VAR _maxYearNumber = YEAR(MAX('Table'[Txn Dt]))
VAR _rowscount = COUNTROWS(FILTER(_summarizeTable,[month] = _maxMonthNumber && [year] = _maxYearNumber))
VAR _averageOfNewAdoption = SUMX(FILTER(_summarizeTable,[month] = _maxMonthNumber && [year] = _maxYearNumber),[average])
RETURN DIVIDE(_averageOfNewAdoption,_rowscount,0)

Final output

If the error persists, can you share the .pbix file without the sensitive data?

 

Best Regards,
Wenbin Zhou
If this post helps,Please mark me and jgeddes  as the solution.