Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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 thanks for your prompt response;
From the best of my knowledge and your answer i did the following based on my data:
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
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
@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
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)
And again, thanks.
Works great. As a beginner i am very glad with your prompt response and solution! Kudos 👍
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |