Forum Discussion

adharsha's avatar
adharsha
Frequent Visitor
4 years ago
Solved

Incorrect grand total

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 - 520
aug - 10  25
aug  - 29  30
july - 15 10

the result is

aug 30
july10

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's avatar
    Jihwan_Kim
    4 years ago

    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] )

     

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      adharsha
      Frequent Visitor
      4 years ago

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