Marco Russo

@marcorus

Consultant, speaker, book writer, mentor. Business Intelligence with Power BI, Analysis Services, and Power Pivot. Other info on sqlbi.com

sqlbi.com/blog/marco/

Joined September 2009

Replies Reposts Media Articles

Pinned
Marco Russo
@marcorus
Jun 26, 2023
After years in “stealth mode,” we’re excited to introduce DAX Optimizer. Dive deeper here: daxoptimizer.com/blog/introduci… DAX Optimizer is a tool – delivered as a service – that helps identify potential bottlenecks and suggests impactful solutions and priorities. You still write the
20
Marco Russo
@marcorus
8h
A DAX calculation can produce convincing values at the detail level and fail at the total. The problem is often that the business rule was evaluated at the wrong granularity. This article+video introduces four grains, or levels of granularity, that should be identified before
Marco Russo
@marcorus
Sep 5
Many-to-many relationships are valid in Power BI, so are bidirectional filters. However, they're not considered best practice, which is different. A best practice in Power BI is what you do by default when you have no reason to make an exception. It's a suggestion, not a
2
Marco Russo
@marcorus
Sep 4
CTRL+V: paste DAX code F6: Format it Highlight the code and teach. It also works with SQL. Interested in other languages? SQLBI Whiteboard is free and open source. whiteboard.sqlbi.com · Microsoft Store: apps.microsoft.com/detail/9NN5N0L… · GitHub: github.com/sql-bi/SQLBI-W…
00:00
3
Marco Russo
@marcorus
Sep 2
A new episode of "The Whiteboard" series, where I talk about matrix totals in Power BI. Special guest: the SQLBI Whiteboard! youtu.be/jbGEXZ85Nr0 #powerbi #dax #whiteboard
Matrix Totals - The Whiteboard #13
From youtube.com
1