new measure based on column value

[Anonymous]

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.

[az38 · Accepted solution]

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]

@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]

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]

@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

[az38]

 @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]

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)

[Anonymous]

@az38 

And again, thanks.

Works great. As a beginner i am very glad with your prompt response and solution! Kudos 👍