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

 Anonymous 

try OR

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

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

lsurmann's avatar
lsurmann
Regular Visitor
3 years ago

Just a question about the soulution with OR operator.
What is if these values have to be variable.

 

IF DimTransactionTypeI = 1 --> then do the sum(DimTransactionTypeI = 1)

IF DimTransactionTypeI = 2 --> then do the sum(DimTransactionTypeI = 2)