Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

summerize differently depending on filter

Hi, because my "Lost_amount"   does not summarize the total, I have created "Lost_amount3"     But depending on how many customers (=CYname) it summarizes differently.   Correct...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Anonymous 
Please share a screenshot along with the dax code you wrote.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

These are all codes I used in the visual

 

 

 

 

 

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Anonymous 
    Try to have Jahr and Monat as real columns in the Date table and use them in the table visual and in the SUMMARIZE 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      do you mean like that?

      I did change it in the visual too, but Lost_new is still empty 

      • tamerj1's avatar
        tamerj1
        Community Champion
        3 years ago

        Anonymous 

        Would you please double check that these are the same columns that are used in the table visual one by one?