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...
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

az38's avatar
az38
Icon for Community Champion rankCommunity 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
      Icon for Community Champion rankCommunity 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        az38 

        Great, That did the trick!!! (simple typo)

         

        And what if is want to ad 2 values for the SUM, so i want the total of value 1 and value 2