Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to calculate and average value for some sales data which works in conjunction with my slicers.
I have some DAX code below which works really well when returning for all of our quoted work.
I need to add an extra filter in to do the same calulation but only when the quote has been accepted. I've tried a number of ways but the values returned are not correct.
The acceptance sits in another table which is connected to my already filtered data via another table. The structure is...
Opportunities, One to Many with Quotes
Quotes, One to Many with Quote Line Items
The filter I need to add is
Solved! Go to Solution.
Thank you @Greg_Deckler for your help. I managed to find a solution without using tables in the end. As shown below.
Your help and input was appreciated.
@ejoneslor You can often use CALCULATETABLE to get the table you want with the filters you want. Hard to be specific without sample data.
Thank you @Greg_Deckler. In my miited previous experience, using a table won;t give me what I need. Tables calculate on load wihich means they don't interact with the slicers or the date ranges as I'd liek them too.
Is it possible to include filters from two different tables in the sam CALCULATE function.
Apologies if my description isn;t great. I'm very new to this.
@ejoneslor You can use CALCULATETABLE in a measure. Basically you can potentially use it to filter the table parameter of your SUMX function for example. Works just like CALCULATE but returns a table.
Thank you @Greg_Deckler for your help. I managed to find a solution without using tables in the end. As shown below.
Your help and input was appreciated.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
107 | |
88 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |