CODEWITHSUNDEEP
filterpowerbidax
Sweepster
Sweepster

Reputation: 1949

Power BI Measure returning Blank when it shouldn't

I am trying to create a measure that will return a value for the number of issued receipts in the year 2020:

CALCULATE(SUM(Receipts[issued]), FILTER(Receipts, Receipts[Year] = 2020))

However, the measure keeps returning blank, even as a calculated column.

I've also tried

CALCULATE(SUM(Receipts[issued]), FILTER(Receipts, Receipts[Year].Year = 2020))

But that is returning an error saying the syntax for "Year" is incorrect.

enter image description here

The Year column is of datatype Date and is linked to a dimDate table on the Date column.

I am trying to retrieve the value 440,000. What am I doing wrong?

Upvotes: 0

Views: 3931

Answers (1)

davidebacci
davidebacci

Reputation: 30344

Try this.

CALCULATE(SUM(Receipts[issued]),  YEAR(Receipts[Year]) = 2020)

Upvotes: 1

Related Questions