A closer look at CALCULATETABLE and SUMMARIZE DAX function used as filter in measures - Power BI

[@darylellis7597]

A difficult/impossible challenge for me is so simply explained. Thank you!

[@PowerBIHowTo]

Thanks, Daryl! Appreciate your feedback. 🙏

[@ZaniCanduçço]

Thank you for your videos sir.
Do you know, which one of those works better on the power bi engine?

[@PowerBIHowTo]

HI Alex, I will get back on this with analysis and let you know. Thanks!

[@ZaniCanduçço]

@@PowerBIHowTo thank you!

[@sandeepreddy7687]

Thanks sir for easy explanation.

[@PowerBIHowTo]

Thanks, @Sandeep!

[@lalitkaushik1812]

Not getting same result in below summarize
PromoCode_3 =
var InvoicePromoCode=SUMMARIZE(
FILTER('Raw Data',
Not ISBLANK('Raw Data'[PromoCode])),
'Raw Data'[Invoice Number])
return
CALCULATE(
SUM('Raw Data'[Sales]),InvoicePromoCode)

[@PowerBIHowTo]

Hi there, Can you share your sample pbix file for me to take a look? Thanks!

[@cesarsaldana3429]

Amazing...... Greetings from Mexico

[@PowerBIHowTo]

Thank you very much! Really appreciate it. Greetings from Canada 🙏