Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measured Total Problem.

Dear All,   When I searched about problems that is related to measured total problem, I have seen many solutions but that does not work for my problem. Although I have wrote a formula based on a lo...
Need Help
  • sturlaws's avatar
    sturlaws
    6 years ago

    sorry, I obviously did not manage to post in the code in my previous post. Here it is:

    measure =
IF (
    HASONEVALUE ( [code] ),
    [brut],
    SUMX ( SUMMARIZE ( 'table', [code], [surname] ), [brut] )
)
  • sturlaws's avatar
    sturlaws
    6 years ago

    and just a little tip, when sharing code(and data), paste the code/data instead of screenshots

sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi, Anonymous,

 

without knowing the code for [brut cb satis], it's difficult to suggest an exact solution.

 

You could try to rewrite your code to this:

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi sturlaws 

     

    Just for your info ,brüt cb satış calculation works well except total sum.

     

    Code as follow :

     

    • sturlaws's avatar
      sturlaws
      Resident Rockstar
      6 years ago

      sorry, I obviously did not manage to post in the code in my previous post. Here it is:

      measure =
IF (
    HASONEVALUE ( [code] ),
    [brut],
    SUMX ( SUMMARIZE ( 'table', [code], [surname] ), [brut] )
)
      • sturlaws's avatar
        sturlaws
        Resident Rockstar
        6 years ago

        and just a little tip, when sharing code(and data), paste the code/data instead of screenshots