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'[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

8 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

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

      Hello,

       

      How to fix this issue to get exact count.

       

      Regards,

      Chandrashekar B

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.