Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

new measure based on column value

I have a pretty much beginner like question:

 

A have a numbers field with sales amounts and my sum/measure must only contain the total amount of sales based on the value of another column. 

 

So for instance:

 

Column A represents my filter value

I want a total sum/measure of Column B based on a specific content in Column A.

 

I dont now if i explained myself correctly but if someone is willing to help i would be glad to provide some more info.

  

measure
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try smth like

    Measure = calculation(sum(ColumnB); FILTER('Table';'Table'[ColumnA]="yourValue"))

    do not hesitate to kudo useful posts and mark solutions as solution

7 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    try smth like

    Measure = calculation(sum(ColumnB); FILTER('Table';'Table'[ColumnA]="yourValue"))

    do not hesitate to kudo useful posts and mark solutions as solution

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      az38 thanks for your prompt response;

       

      From the best of my knowledge and your answer i did the following based on my data:

       

      Measure 2 = CALCULATE(SUM(Financieel[Aantal]; FILTER(Financieel; Financieel[DimTransactionTypeID]=2)))
       
      I get an error when i try to push this. any idea where i am going wrong?
      • az38's avatar
        az38
        Community Champion
        6 years ago

        Hi Anonymous 

        what kind of error?

        i see you dint have a ")" here "SUM(Financieel[Aantal]"

        Measure 2 = CALCULATE(SUM(Financieel[Aantal]); FILTER(Financieel; Financieel[DimTransactionTypeID]=2))

        do not hesitate to kudo useful posts and mark solutions as solution