Forum Discussion

DK-C-87's avatar
DK-C-87
Icon for Helper I rankHelper I
9 months ago
Solved

Wrong total in table

Hi everyone Hope there is some one out there that can help me 🙂 I have tried myself to correct the total sum in my table (Filtreret benchmark to be total of 8.302.774): My measure is:...
Need Help
  • amitchandak's avatar
    amitchandak
    9 months ago

    DK-C-87 , Try this return 

    SUMX(
    Summarize('3_Stamdata', '3_Stamdata'[Oms cluster], '3_Stamdata'[Plant - Butik]),
    CALCULATE(_Resultat)
    )

    Or 

    Return 
    _Resultat

    And then create a new measure 

    =SUMX(
    Summarize('3_Stamdata', '3_Stamdata'[Oms cluster], '3_Stamdata'[Plant - Butik]),
    [Filtreret benchmark]
    )

    Also, you should use a date table for all time intelligence functions datesinperiod. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
9 months ago

DK-C-87 , Try this return 

SUMX(
Summarize('3_Stamdata', '3_Stamdata'[Oms cluster], '3_Stamdata'[Plant - Butik]),
CALCULATE(_Resultat)
)

Or 

Return 
_Resultat

And then create a new measure 

=SUMX(
Summarize('3_Stamdata', '3_Stamdata'[Oms cluster], '3_Stamdata'[Plant - Butik]),
[Filtreret benchmark]
)

Also, you should use a date table for all time intelligence functions datesinperiod. 

DK-C-87's avatar
DK-C-87
Icon for Helper I rankHelper I
9 months ago

Thank you so much ! 🙂
It was the last solution with a new measure that did it for me