topic new measure based on column value in DAX Commands and Tips

new measure based on column value

Anonymous — Wed, 27 Nov 2019 13:09:12 GMT

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 — Wed, 27 Nov 2019 13:19:25 GMT

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 — Wed, 27 Nov 2019 13:27:23 GMT

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 — Wed, 27 Nov 2019 13:30:05 GMT

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 — Wed, 27 Nov 2019 13:39:04 GMT

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 — Wed, 27 Nov 2019 13:43:12 GMT

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

Anonymous — Wed, 27 Nov 2019 13:48:11 GMT

And again, thanks.

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

lsurmann — Fri, 02 Dec 2022 10:35:53 GMT

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)