cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## DAX Sum function with Where condition

Hi,

I need help in creating the DAX formula, one created is not working correctly

this is SQL query

SELECT
CreatedMonth,
Product,
SUM(Value)
FROM Table1

WHERE
CreatedMonth = ReportingMonth

GROUP BY
CreatedMonth
Product
ORDER BY CreatedMonth

SQL query result

 CreatedMonth Product Sum_Value FP2021.08 XYZ 1219 FP2021.09 XYZ 811 FP2021.10 XYZ 286 FP2021.11 XYZ 280 FP2021.12 XYZ 543 FP2022.01 XYZ 1412 FP2022.02 XYZ 561 FP2022.03 XYZ 586 FP2022.04 XYZ 300 FP2022.05 XYZ 304 FP2022.06 XYZ 382

But when created DAX formula

Sum_Created = CALCULATE(Sum(Table1[Value]),Table1[CreatedMonth] = Table1[ReportingMonth])

Getting the result from PBI, giving entire total for each month. also,I added reportingmonth to the table even then no change

1 ACCEPTED SOLUTION
Super User
``````Sum_Created = //try this one might help you
SUMX(
FILTER(
Table1,
Table1[CreatedMonth] = Table1[ReportingMonth]
),
Table1[Value]
)
``````

Did I answer your question? If so, please mark my post as a solution!

Proud to be a Super User!

2 REPLIES 2
Helper II

thank you so much for quick reply, it worked!!

Super User
``````Sum_Created = //try this one might help you
SUMX(
FILTER(
Table1,
Table1[CreatedMonth] = Table1[ReportingMonth]
),
Table1[Value]
)
``````

Did I answer your question? If so, please mark my post as a solution!

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors