***** Related Links***** How To Understand Virtual Tables Inside Iterating Functions In Power BI - DAX Concepts - blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/ Using Iterating Functions SUMX And AVERAGEX In Power BI - blog.enterprisedna.co/using-iterating-functions-sumx-and-averagex-in-power-bi/ Working With Iterating Functions In DAX - blog.enterprisedna.co/group-customers-dynamically-by-their-ranking-wdax-in-power-bi/ ***** Related Course Modules***** Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations Advanced DAX Combinations - portal.enterprisedna.co/p/advanced-dax-combinations DAX Formula Deep Dives - portal.enterprisedna.co/p/learning-summit-series ***** Related Support Forum Posts***** DAX Virtual Table Logic To Modify Context - forum.enterprisedna.co/t/dax-virtual-table-logic-to-modify-context/2580 Filtering a measure created in a virtual table - forum.enterprisedna.co/t/filtering-a-measure-created-in-a-virtual-table/1601 Virtual Tables And Problem With Time Intelligence DAX Functions - forum.enterprisedna.co/t/virtual-tables-and-problem-with-time-intelligence-dax-functions/5151 For more virtual table support queries to review see here - forum.enterprisedna.co/search?q=virtual%20table
Hello, how can I do the formula, if the measure consists on having the average price from one table and multiplying with the quantity from another table that are related??
Grand total for Minimum Testing measure is not correct. It is showing the sum of Sales_LY where customer is not blank for both Total sales and Sales_LY measures.
Hello Anilkumar, Thank You for posting your query onto our channel. Well to fix the grand totals, one of our expert had already created a magnificent post onto our Community Forum which covers all the types of real life scenarios as well as also contains the link of the videos. Below is the link of that post provided for the reference. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Also make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html forum.enterprisedna.co/t/fix-incorrect-totals/8834
I have a challenge for you Sam. I am trying to use this technique to calculate Price Effects. Price Effect (Wrong total)= VAR Price = [Quantity CY] * ( [Average Price CY] - [Average Price PY] ) VAR PriceTotal = SUMMARIZE( Data, Data[Product ID], "Price Effect", Price) RETURN IF( HASONEVALUE( Data[Product ID] ), Price, SUMX( PriceTotal, [Price Effect])) No luck so far 😞
I've found it doesn't really matter. Maybe if you have a huge dataset and milli second performance differences matter to you, but you're talking about less than 1% of occurrences there. Keep it simple I say.
***** Related Links*****
How To Understand Virtual Tables Inside Iterating Functions In Power BI - DAX Concepts - blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/
Using Iterating Functions SUMX And AVERAGEX In Power BI - blog.enterprisedna.co/using-iterating-functions-sumx-and-averagex-in-power-bi/
Working With Iterating Functions In DAX - blog.enterprisedna.co/group-customers-dynamically-by-their-ranking-wdax-in-power-bi/
***** Related Course Modules*****
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
Advanced DAX Combinations - portal.enterprisedna.co/p/advanced-dax-combinations
DAX Formula Deep Dives - portal.enterprisedna.co/p/learning-summit-series
***** Related Support Forum Posts*****
DAX Virtual Table Logic To Modify Context - forum.enterprisedna.co/t/dax-virtual-table-logic-to-modify-context/2580
Filtering a measure created in a virtual table - forum.enterprisedna.co/t/filtering-a-measure-created-in-a-virtual-table/1601
Virtual Tables And Problem With Time Intelligence DAX Functions - forum.enterprisedna.co/t/virtual-tables-and-problem-with-time-intelligence-dax-functions/5151
For more virtual table support queries to review see here - forum.enterprisedna.co/search?q=virtual%20table
Hello, how can I do the formula, if the measure consists on having the average price from one table and multiplying with the quantity from another table that are related??
Grand total for Minimum Testing measure is not correct. It is showing the sum of Sales_LY where customer is not blank for both Total sales and Sales_LY measures.
Hello Anilkumar,
Thank You for posting your query onto our channel.
Well to fix the grand totals, one of our expert had already created a magnificent post onto our Community Forum which covers all the types of real life scenarios as well as also contains the link of the videos. Below is the link of that post provided for the reference.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements that you've been looking for. Also make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI.
Happy Learning!
Thanks and Warm Regards,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
forum.enterprisedna.co/t/fix-incorrect-totals/8834
I have a challenge for you Sam.
I am trying to use this technique to calculate Price Effects.
Price Effect (Wrong total)=
VAR Price = [Quantity CY] * ( [Average Price CY] - [Average Price PY] )
VAR PriceTotal = SUMMARIZE( Data, Data[Product ID], "Price Effect", Price)
RETURN
IF( HASONEVALUE( Data[Product ID] ),
Price,
SUMX( PriceTotal, [Price Effect]))
No luck so far 😞
Hi Chris, please find all forum posts on fixing complex total errors here:
forum.enterprisedna.co/search?q=fixing%20complex%20total
Marco and alberto insists not to add columns within summarize... But use ADDCOLUMNS with SUMMARIZE
I've found it doesn't really matter. Maybe if you have a huge dataset and milli second performance differences matter to you, but you're talking about less than 1% of occurrences there. Keep it simple I say.