Incorrect grand total

[adharsha]

Hi,

I wanted to calculate the number of distinct rows that are present based on a few columns and take only the values whose dates are
maximum for each month.
example:

aug - 5	20
aug - 10	25
aug  - 29	30
july - 15	10

the result is

aug	30
july	10

I have writen the dax for it,
CALCULATE(
COUNTROWS(
DISTINCT(SELECTCOLUMNS('table',"Id",'table'[Id],"StateName", 'table'[StateName], "LoadDate", table'[LoadDate]))),FILTER('table','table'[Score]>0 && 'table'[date_number]=max('rpt VwFPODigitizationScorepivot'[date_number])))

but the grand total is incorrect, so it becomes incorrect when i take percentage of row total.
How can i get the correct grandtotal as = 97+84 = 181

Thankyou

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please try to write a new measure something like below, and replace a current measure with the new one.

New measure: =
SUMX ( VALUES ( calendartable[month_name] ), [your current measure] )

[adharsha]

Thank you, didn't think in this way that I could write another measure to achieve the result.