Alberto Ferrari

Every single screenshot... DAX is soooo simple, compared to aligning a relationship!

Learn how to highlight a single data point among a distribution in #PowerBI; no custom visuals required. Bonus if you like D&D, cause we're analyzing the statistics of monsters. It's summer after all, let's have fun with it. 📝 sqlbi.com/articles/highl… 📽️ youtu.be/l0DETT4QR_Y?si…

@ehansalytics I hate to admit it… but ALL is so much more sexy than REMOVEFILTERS… there’s this see-not-see thing that makes me use it more often than I should! :))

I met another Power BI developer at Starbucks today. Nice guy. We talked for a bit. I then asked him if he wanted to remove all filters from a table inside a CALCULATE() which he used: ALL(Table) -or- REMOVEFILTERS(Table) He said ALL() I promptly got up, left, and deleted his contact from my phone.

@MarkWalterCPA This looks like a smart statement. Just can’t believe I wrote it! :)

Goals: “A good DAX developer already starts the optimization process when writing the formulas: you mentally picture how the code will be executed, and with that in mind you attempt to write efficient DAX code right from the start” Ch.9 Optimizing DAX 2nd Edition. #DAX #SML

Hints from a book from the future: “Honestly, it would be better to be a good data modeler and a mediocre DAX author than a DAX guru but a poor data modeler. Therefore, if data modeling is not your cup of tea, roll up your sleeves and start learning it. Maybe during the pauses, while reading this book: you will attain two great goals at once.”

The 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗶𝗻𝗴 𝗗𝗔𝗫 book (aka 𝗧𝗵𝗲 𝗕𝗿𝗶𝗰𝗸, as it is 800+ pages) is now 𝗮𝘃𝗮𝗶𝗹𝗮𝗯𝗹𝗲: - Paperback (Black & White) - Hardcover (Color) - eBook (PDF, Kindle, ePub) 𝗥𝗲𝗮𝗱 𝗺𝗼𝗿𝗲: sqlbi.com/articles/the-o… 𝗢𝗿𝗱𝗲𝗿 𝗼𝗻𝗹𝗶𝗻𝗲: sqlbi.com/books/optimizi…

@ehansalytics Mine is six… I just cannot think about any other way to work…

Fact Check: ✅

𝗗𝗶𝗿𝗲𝗰𝘁 𝗟𝗮𝗸𝗲 𝘃𝘀. 𝗜𝗺𝗽𝗼𝗿𝘁 𝗺𝗼𝗱𝗲 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 What is the right choice between Direct Lake and Import mode in Power BI? #powerbi #vertipaq #directlake #import sqlbi.com/blog/marco/202…

The 𝘃𝗶𝘀𝘂𝗮𝗹 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗼𝗻𝘀 in #powerbi introduced a new concept: the 𝘃𝗶𝘀𝘂𝗮𝗹 𝗰𝗼𝗻𝘁𝗲𝘅𝘁. This article+video introduces EXPAND and COLLAPSE, two functions to navigate the visual context. #powerbi #visualcalcs sqlbi.com/articles/intro…

I will speak at SqlBits 2024 in Farnborough and at the Microsoft Fabric Community Conference in Las Vegas! #sqlbits #fabricconf

I am glad to announce that @kurtbuhler has started to work with us at SQLBI. The video describes the most difficult part of the job. 😎 Read more: sqlbi.com/blog/marco/202…

This article+video from @kurtbuhler describes the different approaches to format your #dax measures in #powerbi semantic models using format custom and dynamic format strings. sqlbi.com/articles/impro…

Short, sad story. Once upon a time, there was a 𝙡𝙖𝙯𝙮 data modeler. Their semantic model did not work. End of the story. Credits: @FerrariAlberto #powerbi #datamodeling

@Rad_Reza Sorry to hear this, Reza. Words are useless… a big hug!

Leila passed away 8 am today 31st if December 2023. I never have seen anyone suffering so much yet be always positive She was the symbol of bravery and strength She was a loving wife, best friend, tech guru, and most importantly an amazing human being. In my life I am honored to call her not only my life partner but also mentor. Our world was very small for her big heart I had the privilege of being with her for 17 years, the best years of my life She endured unbearable suffering in the past 11 months. She is in peace now, no more pain for you. Such a big loss for me, your friends, the global Microsoft community and anyone who knew him.

I was fortunate to meet the #DAX grandmaster @FerrariAlberto in person, the experience was incredibly gratifying and amazing. 🤩 I am immensely grateful for the opportunities provided by @SQLMissSunshine , @oengels and @_Tillmann . You guys are amazing! #gratitude #grateful

This article+video shows how to compute ratios when row-level security hides some of the data, and you need a percentage that includes the hidden rows in the comparison. #powerbi #dax sqlbi.com/articles/compu…

The DirectQuery over SQL section of the Optimizing DAX video course is now available! More than five additional hours of lectures, assuming you know how to optimize SQL afterward. #dax #optimizingdax #powerbi Read more: sqlbi.com/blog/marco/202…

Are you ready for SQLBi-ts Unveiled?😉 The #SQLBI team - @marcorus and @FerrariAlberto - are taking to the stage to officially announce #SQLBits2024!🔍 Join us LIVE on your desired platform, links below!🔗 3PM EU, 2PM UK, and 9AM East Coast THURSDAY 14TH SEPTEMBER!📅

Obtaining a straight line with an arrow pointing left to right in the diagram view of Power BI Desktop is insanely hard. Next time you see a figure like this, appreciate the effort! :)

Inside Calculation Groups is available. It is a deep dive into calculation groups in #dax: multiple calculation groups, precedence, sideways recursion, composite models, and several DAX Patterns as a calculation group. For #powerbi and #ssas #tabular. sqlbi.com/blog/marco/202…