Forum Discussion
Calculate % based off total, rather than selected
Wouldn't this new measure be incorrect though?
TotalCloseCode = COUNTROWS('Closed Changes')
This would count the rows of all data rows that keep getting appended. But I would be calculating the percentage individually for each month. How can I get it that it will only count the rows individually for each month, without having to add a new measure each month ?
Can anyone confirm it is possible to calculate percentage of just those selected month over month, where new data will continue to be appended? If I use the Countrows option, it will count all the rows for all the months. Unless there is another way to calculate the percentage so that it keeps the true percentage and doesn't recalculate % values after doing selections/filtering.
I don't want to have to add a new measure every month, else in a couple of years, there will be quite a few new measures.