Forum Discussion

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
4 years ago
Solved

Incorrect measure total in Matrix

Hi Experts, Greg_Deckler  I have tried using summarize, sumx and hasonevalue function still giving incorrect result in total. I have used 3 different measure which I have written below Measure 1 ...
Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Uzi2019 , Try to use something like below:

    IF(HASONEFILTER('Table'[Month]),C*(%Sum),SUMX(VALUES('Table'[Month]),C*(%Sum)))
     
    Hopefully it may help you out.
     
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hey Uzi2019 ,

 

what exactly should the result be?

Can you provide a sample file? It's a little difficult to help you with that small amount of information.

 

Best regards

Denis

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
4 years ago

Hi selimovd ,
I want answer to be 2032819+544684=2577503 for final measure

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Uzi2019 Can you share the file or create a sample file if the content is confidential? 

    • Uzi2019's avatar
      Uzi2019
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Hi selimovd 

      sorry but cant share the file it has confidential data.
      can u help me by looking at this image? or suggest some measure which gives correct total.

       

       

      • selimovd's avatar
        selimovd
        Icon for Most Valuable Professional rankMost Valuable Professional
        4 years ago

        Uzi2019 it looks like it could be semi additive values, but you have to share more information.

         

        If the data is confidential, then please create a similar file with fake data and the same behavior. But if you just say "look, it's wrong" and don't provide more information I don't know what to tell you.