Forum Discussion
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 - 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
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
Super User
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] )Thank you, didn't think in this way that I could write another measure to achieve the result.
