Forum Discussion
TOTALYTD in Distinct count
Hi Team, I am new to Bi and a requirement came in front of me to show the data in a cummulative way. I was using the TotalYTD for the same but the expression which i am using in YTD contains the D...
Hi Anonymous ,
What you're trying to achieive is not YTD but rather a cumulative count or sum. The concept of YTD is tha a calculation resets at every change of year (calendar or fiscal). Try this instead:
cumulative = CALCULATE ( DISTINCTCOUNT ( 'table'[column] ), FILTER ( ALL ( 'table' ), 'table'[year] = MAX ( 'table'[year] ) ) )the formula above assumes that you don't have separate dates table and you're only calculating for the cumulative sum/count by year and not for every date.
Hi !!
Thanks for your answer the same thing i applied and got the answers. But thanks for your time and efforts. Really Appreciate.