Measure

[Govardhan118]

I have inserted a table in Power BI report. Just 2 columns "Total Sales" and "February Sales". The DAX measures for these are as follows-
Total Sales =
SUM('sales'[amount])
February Sales =
CALCULATE(Total Sales, FILTER(ALL(calendar), 'calendar'[month] = 2))

I must say that I am new to Power BI, started learning it recently.
I want to ask, is there any error in my DAX? I do not have any page-level or visual-leve filters.
For some reason, the "Total Sales" and "February Sales" are one and the same. No change in numbers. Can someone help me with this. I am unable to figure out what is wrong. For context, I downloaded the Desktop app from the Store. I don't know how this information helps, but is the issue that the app is not functioning?

[Idrissshatila]

Hello @Govardhan118 ,

Are you sure that they are really not equal ?

is there a relationship between the date table and the sales table ?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Govardhan118]

I did. I checked the values returned by the 2 measures. They both are the same, I even checked it for different years, they were the same.
I do want to ask, is my DAX Code correct? I am trying to understand how filter modifying functions work. There is a one-to-many relationship between the 'calendar' table (dates table) and the 'sales' table, with 'sales' being on the many side of the relationship.

[mickey64]

Most of the time I use this formula.

    February Sales = SUMX(FILTER('sales','calendar'[month]=2),sales'[amount])

Please try that formula below, too.

    February Sales = CALCULATE(Total Sales, 'calendar'[month] = 2)

[Govardhan118]

I used the 2 formulas above. The first one couldn't be written despite there being a one-to-many relationship between my 'sales' (facts) table and 'lookup_dates' table. I do have to mention that, I came across a previous issue where I had to mark the 'lookup_dates' table as Date Table and use the 'dates' column as the Date Column. Since then, I cannot refer the column in FILTER().
The second formula worked very easily.
Thanks a lot for the help.

[Govardhan118]

These are so much better than mine. Thanks a lot. I will try them and see whether there's a difference.