Forum Discussion

user_unknown39's avatar
user_unknown39
Icon for Helper I rankHelper I
5 years ago

Distinct count column shows incorrect grand total for date slicer

Hi,

 

This is my column that shows a distinct count of products by store for YTD. The row values are fine but the grand total is off. I just want the grand total to show a sum of all the values.

My code is as follows:

 

number_brands_YTD =
CALCULATE(
DISTINCTCOUNT('sv on_op_src3'[BrandName]),
FILTER(
ALL('Calendar'),
'Calendar'[Date] >= EDATE( DATE( YEAR(TODAY()), 1, 1 ), 2 )
&& 'Calendar'[Date] <= MAX('Calendar'[Date])
)
)
I also have a date slicer in place. What would be the best way to resolve this issue?
 
Thanks,
 
General Comment
Need Help
Show and Tell

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Try this measure

    number_brands_YTD =
    CALCULATE(DISTINCTCOUNT('sv on_op_src3'[BrandName]),DATESYTD('Calendar'[Date],"31/12"))
    Hope this helps.