Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
Solved! Go to Solution.
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
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?
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
User | Count |
---|---|
51 | |
36 | |
20 | |
15 | |
13 |
User | Count |
---|---|
94 | |
72 | |
29 | |
22 | |
13 |