topic Re: Wrong Table Total in DAX Commands and Tips

Wrong Table Total

Chandrashekar — Mon, 16 Jan 2023 11:01:01 GMT

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

Re: Wrong Table Total

m-kats — Mon, 16 Jan 2023 13:41:50 GMT

Hello Chandrashekar ,

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

Re: Wrong Table Total

FreemanZ — Mon, 16 Jan 2023 14:02:25 GMT

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.

Re: Wrong Table Total

Chandrashekar — Mon, 16 Jan 2023 14:47:59 GMT

Hello,

How to fix this issue to get exact count.

Regards,

Chandrashekar B

Re: Wrong Table Total

Anonymous — Tue, 17 Jan 2023 07:52:20 GMT

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.

Re: Wrong Table Total

Chandrashekar — Tue, 17 Jan 2023 09:04:20 GMT

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])

Re: Wrong Table Total

Anonymous — Tue, 17 Jan 2023 09:30:49 GMT

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.

Re: Wrong Table Total

Chandrashekar — Tue, 17 Jan 2023 09:34:25 GMT

Hello,

Thanks. I will check and let you share result.

Re: Wrong Table Total

Chandrashekar — Tue, 17 Jan 2023 10:09:35 GMT

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