Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

multiple conditions + calculation

Hi Community,   following problem. My calculation with multiple conditions including addition does not work       Here is my formula that doesn't work:    If(and( Category ="Küche" && Order ...
Need Help
Tips and Tricks
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Hi, I just noticed that the values are not added up.

Can you please help me again.

000115.jpg

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Syndicate_Admin , It is not required. You can directly use this column on your visual and mark summerization as SUM  or create a measure with below code and use it:-

measure = Sum(Tabelle2[column])

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you. But I do not want to make the sum of all projects, such as summerization.

    Calculation within the formula would need to be adjusted.
    In the formula the result is 100, but it should be 200.