Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |