Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SUMX and ALLEXCEPT

Hello, I'm struggling with a specific formula to be implemented in DAX. My dataset has several dimensions but I have to apply this formula at a certain level of granularity, therefore I have to cal...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ï¼Œ

    You can update the formula of measure [Measure SUMX] as below, please find the details in the attachment:

    Measure SUMX = SUMX(SUMMARIZE('SAMPLE_FT','SAMPLE_FT'[COUNTRY],'SAMPLE_FT'[TECH],"nCheck",[Check]),[Measure])

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ciao Anonymous ,

thanks for your reply.

Here is a sample file with sample data. I tried to reproduce as much as possible my data model.

As you can see the total value of the "Measure SUMX" is not the sum of the values at Country-Tech level. 

 

Fabio

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ï¼Œ

You can update the formula of measure [Measure SUMX] as below, please find the details in the attachment:

Measure SUMX = SUMX(SUMMARIZE('SAMPLE_FT','SAMPLE_FT'[COUNTRY],'SAMPLE_FT'[TECH],"nCheck",[Check]),[Measure])

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you very much!

    I'm including this solution to the real file and let accept it as solution (if it works 😉 ).

    Meanwhile thank you again!

     

    Fabio

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ï¼Œ

      OK. Looking forward to your reply. Any comment or problem later, please feel free to let me know. 

      Best Regards

      Rena