Distinct Count totaling in measure

[PBIX_COACH]

Hello Friends

I need some help to get my total in column D to show as 2 and not 4

below is the formula I'm currently using which gives the correct count but not for the total.

Chat by week =

var vadeochat = CALCULATE([Video Chat Dt],USERELATIONSHIP('03 all-contacts'[Video Chat Date],'CalendarDim'[Date]))

return

     IF(

        ISINSCOPE(CalendarDim[Start of Week])=FALSE(),

        vadeochat,

        COUNTAX(SUMMARIZE(CalendarDim,CalendarDim[Start of Week],"__Value",vadeochat),[__Value]))

[Jihwan_Kim · Accepted solution]

Hi, 

It is quite difficult without knowing how the data model looks like, but please try to write a new measure that looks something like below and add to the table visualization whether it suits your requirement.

Total fix measure: =
SUMX (
    SUMMARIZE (
        'FactTableName',
        'CalendarTable'[columnname that contains A],
        'TableName'[columnname that contains B]
    ),
    [Chat by week measure]
)

[PBIX_COACH]

thanks @Jihwan_Kim working now

[PBIX_COACH]

@Anonymous Tried it out and it's not working giving me the same result

[Anonymous]

Hello @PBIX_COACH  if column d is a measure 

Just create a mew measure:

Correct value = IF(HASONEVALUE(Table[Column A],[measure of column D],SUMX(VALUES(Table[Column A]),[measure of column D]))