Wrong Table Total

[Chandrashekar]

Hello,

am getting wrong total(am getting 5815 instead of 6584) .

I am using below measure for calcuation.

Measure1
EIP = CALCULATE(COUNT('MS'[u_number]),USERELATIONSHIP('MS'[DateOpened_Measure], 'Calendar'[Date]))

Measure2
EP_Pr = CALCULATE([EIP],'MS'[Flag_Service]=1,'MS'[+Include_Eng]="Yes",'MS'[task.u_major]=Blank())

Measure3
EP_DC_CI = CALCULATE(DISTINCTCOUNT('MS'[New_Col_CI]))

Measure4
U_CI_EP_Pr = CALCULATE([EP_DC_CI], filter('MS',CALCULATE([EP_Pr])))+0

Regards,

Chandrashekar B

[v-tangjie-msft]

Hi @Chandrashekar ,

Please try creating the following measure instead of [Measure] as shown in your image:

_Measure =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[RowName],
        'Table'[ColumnName],
        "total", [Measure] //your measure   
    ),
    [total]
)

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Chandrashekar]

Hello,

I tried below Measure but am not getting result. Sorry could not able to share sample as it is huge data. 

Measure1 = sumx(
SUMMARIZE('MS',
'MS'[+Pro_New1],
'MS'[New_Col_CI],
"Total",[UniCI_EPP]
),
[Total])

[v-tangjie-msft]

Hi @Chandrashekar ,

You can refer to the following documents that may be helpful to you:

sum error - Microsoft Power BI Community

Dealing with Measure Totals - Microsoft Power BI Community

Fixing Incorrect Totals Using DAX Measures In Power BI | Enterprise DNA

How to Make Measures Total Correctly in Power BI Tables - ArcherPoint

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Chandrashekar]

Hello,

Can you let me know how to add sumx for below measure. I used separate measure for Sumx and got the expected result.  Is it possible to add sumx for below measure to avoid new measure for sumx .

UniqueCI_EnteredPeriod_Process =

    CALCULATE([EnterPeriod_DC_CI],

                        filter('MNS Workload',CALCULATE([EnteredPeriod_Process])))

 Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Thanks. I will check and let you share result.

[FreemanZ]

hi @Chandrashekar 

this happens because one item could present at different categories and is thus counted 1 in each category. But at the total row, it is counted only 1. 

[Chandrashekar]

Hello,

How to fix this issue to get exact count.

Regards,

Chandrashekar B

[m-kats]

Hello @Chandrashekar ,

which of the above measures are you using in the table?