Forum Discussion
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 - 5 20 aug - ...
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] )
Jihwan_Kim
Super User
Super UserHi,
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.