topic Re: Do I need to use the filter funtion? in DAX Commands and Tips

Do I need to use the filter funtion?

Anonymous — Wed, 06 May 2020 22:25:20 GMT

Hello,

I am trying to calculate sales total only for fiscal year 2020. Any ideas why the below DAX measure wont work? If I try to use the FILTER function it tells me "incorrect parameter used"

CALCULATE('Invoice'[Sales Amount - Total], ('Invoice Date'[Fiscal Year Name] = 2020))

Re: Do I need to use the filter funtion?

Greg_Deckler — Wed, 06 May 2020 23:20:52 GMT

Well you are kind of technically using the FILTERS function already, that's just syntax sugar. I believe the fully canonical of what you have is:

CALCULATE('Invoice'[Sales Amount - Total], FILTER('Invoice Date', 'Invoice Date'[Fiscal Year Name] = 2020))

But, tough to say, maybe a missing relationship or wrong tables and column names? Who knows. Could be a lot of things.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: Do I need to use the filter funtion?

HotChilli — Wed, 06 May 2020 23:33:02 GMT

What's happening with the measure in it's current form?

And is 'Invoice'[Sales Amount - Total] a measure?

Is [Fiscal Year Name] a number or text type?

Are the 2 tables related?