When I sum the value in the table it showing wrong value

[aamirkhan_WT]

Hi All

I need urgent help in below qurey where I am getting wrong value in the table. Its supposed to show 78 adding all the number in the table

78 = if I export that same table to CSV and add it up
Dax Query

Total Version_Update = IF(

    HASONEFILTER(

        WH_WorkflowConfiguration[Workflow (Detailed)]),[Total Versions],

        SUMX(

            VALUES(Activity[Activity ID]),[Total Versions])

            )

[MohammadLoran25 · Accepted solution]

New Measure
VAR _TABLEE =
ADDCOLUMNS (
VALUES ( 'DDate'[YearMonth] ),
"@MYMEASURE", [Total Version_Update]
)
RETURN
SUMX ( _TABLEE, [@MYMEASURE] )

Hi

It is about the context and DAX Behavior for showing results in total context.

Writing a new measure like above-mentioned format would definitely solve your problem.

But I have to mention that it is not the best solution as I do not have the details of your data and data modeling.

Best Regards

[aamirkhan_WT]

AS per above query it show like this below 

In the table it showing wrong total. Now its showing in the Total 2 and it supposed to be 3 

[MohammadLoran25]

You can do the same for this problem as well.

[aamirkhan_WT]

Is there any suggent how add those value 2+1 = 3