Nice explanation. If my understanding we use this function to replicate an agrregation query. Is the equivalent query for the first example is below: SELECT YEAR, BRAND, SUM(Amount) Amount, SUM(Quantity) Qty FROM Sales left join Date on Sales.Date = Date.Date left join Product on Sales.ProductID = Product.ProductID GROUP BY YEAR, BRAND HAVING YEAR IN (2008,2009) AND Product.Color IN ('Red','Blue')
Very informative. Question: You have "CY2008" and "CY2009" hard-coded in the measure. What would the correct syntax be if the user needed to select the date range or the color?
How one can fix column values and include resulted values in the grouping? Some products are split into two groups of RXN and RXR Is it posible to add column like below: "Type", SWITCH([Group],"RXN","RX","RXR","RX",[Group])
How to refer to a column like Product or Country from summarizecolumn in Values() or such similar function? I want use these values as filter in another DAX
I have a question for you. I will be happy if you can make a video out of it, if possible. I am having trouble with my Matrix totals. Power Bi for some strange reason doesn't do a good job when it comes to totals and subtotals. What is the best way to fix incorrect totals?
Look at the differences on dax.guide SUMMARIZECOLUMNS is usually better than SUMMARIZE, but it can't be used in measures so SUMMARIZE still has a place.
Nice explanation. If my understanding we use this function to replicate an agrregation query. Is the equivalent query for the first example is below:
SELECT YEAR, BRAND, SUM(Amount) Amount, SUM(Quantity) Qty
FROM Sales left join Date on Sales.Date = Date.Date
left join Product on Sales.ProductID = Product.ProductID
GROUP BY YEAR, BRAND
HAVING YEAR IN (2008,2009)
AND Product.Color IN ('Red','Blue')
I love your videos! Always on the spot! short and clear! Thank you!
hi, appreciate your valueable guide videos... i have started learning Power BI and these will be much helpful to become expert in near future 😊
Thank you. You made it look so simple 👍
Super useful tutorial. Congratulations for the Euro win!
Perfectly explained 👏. Thank you.
Very informative. Question: You have "CY2008" and "CY2009" hard-coded in the measure. What would the correct syntax be if the user needed to select the date range or the color?
So in your last example you could use SUMMARIZE and ADDCOLUMNS to avoid the issue in the measure right?
br
Thanks, Nicely explained!
How one can fix column values and include resulted values in the grouping?
Some products are split into two groups of RXN and RXR
Is it posible to add column like below:
"Type", SWITCH([Group],"RXN","RX","RXR","RX",[Group])
How to refer to a column like Product or Country from summarizecolumn in Values() or such similar function? I want use these values as filter in another DAX
I have a question for you. I will be happy if you can make a video out of it, if possible. I am having trouble with my Matrix totals. Power Bi for some strange reason doesn't do a good job when it comes to totals and subtotals. What is the best way to fix incorrect totals?
Take a look at these articles/videos:
www.sqlbi.com/articles/obtaining-accurate-totals-in-dax/
www.sqlbi.com/articles/summing-values-for-the-total/
Thank you
what is difference between summarize and summarizecolumns in power bi
Look at the differences on dax.guide
SUMMARIZECOLUMNS is usually better than SUMMARIZE, but it can't be used in measures so SUMMARIZE still has a place.
Totaly useless function which cannot be used in 99,99999% of scenarios.
never had have heard of ROLLUPADDISSUBTOTAL before :-)