Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver III
3 years ago

Wrong Table Total

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'[DateOp...
Chandrashekar's avatar
Chandrashekar
Resolver III
3 years ago

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    Chandrashekar
    Resolver III
    3 years ago

    Hello,

     

    Thanks. I will check and let you share result.

  • Chandrashekar's avatar
    Chandrashekar
    Resolver III
    3 years ago

    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