Deep dive into measure filters in Power BI Desktop

Подписаться 106 тыс.

Просмотров 38 тыс.

50% 1

In this video, we perform a deep analysis of the DAX queries generated by Power BI when you use a measure as a filter in a Power BI visual.
The DAX code generated might show a different behavior whether the measure is part of the values shown in the visual or not.
Article and download: sql.bi/721618?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

Наука

Опубликовано:

13 сен 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 25

@sane7263 2 года назад

Enjoying DAX because of you! Thanks Alberto😀

@Amr-Ibrahim-AI 2 года назад

Thanks Alberto for the detailed explanation! I enjoyed the thought process and learned A LOT from this valuable video

@sriramsundar4 2 года назад

This is such an excellent explanation!! Thank you

@khurramshahzed4925 Год назад

I couldn't find the way, how I thanks to you for your devastating effort to teach. Allah bless you with health, prosperity and knowledge. Ameen. You are

@ejazahmedev 2 года назад

Thank you for democratizing such advanced knowledge. God Bless!

@fr1sket363 2 года назад

Yes i have seen this very example in a report i built, the difference is now i understand why 😆. Thanks so much.

@Bharath_PBI 2 года назад

That's Bananas and interesting to know the behaviour of summarizecolumns() and allselected (). Thank you. 👍

@matthewdufty606 Год назад

I love this video. Thank you for making it ✅🌹💫

@brianligat9493 7 месяцев назад

You guys are wearing out my Like button.

@IoriYagamiKOF98 2 года назад

instead of modify the base measure [Amt], coudln't you modifiy the [Ranking] measure Inside the RANKX by adding a zero to the CALCULATE ([Amt]...) +0 ?, so the base Measure [Amt] keeps returning blank for future reports?

@SQLBI 2 года назад

It looks like a good option. The video is more about how to find the issue and debug it. The solution, then, really depends on the specific requirements. Thanks for bringing this to our attention!

@pbihari0214 2 года назад

Thank you

@MrJrhzues 5 месяцев назад

TOP PERFORMERS BY YEAR

@kalinduSekara 2 года назад

Great 👍

@LuciusSullaFelix 2 года назад

I’ve booked marked this video so I can come back to this again as I didn’t follow the entire concept.

@christianstork1049 2 года назад

Thanks for this detailed analysis. Worth its time already because of the methodology. However, to be honest, this seems more like a sophisticated illustration of a bug in Power BI. An internal optimization shouldn't justify occasional incorrect results nor cause extra work on behalf of the users. :-(

@porraloka31 2 года назад

If powerBi had to calculate every single blank value it'd speed down the engine quite a lot and we'd complaining about how slow PowerBi is.

@Davide73 2 года назад

You are right - PowerBI is full of bugs that are "feature"... on the top of the list there is the so called "Auto Exist"; what is very funny is that MS Excel doesn't have it. It has been introduced in the PowerBI engine. The problem is that Microsoft and their evangelist will never admit them, so they will never be fixed.

@odeddror8916 2 года назад

What will happened if we use Top 2 Descending instead of ranking?

@johnjiang7456 Год назад

It is a great video! I have a similar issue that uses a measure as a slicer( you use filter, a little different). I am not able to solve the problem. Like your example, if I would like to show all sales that ranked the top 2 for each year, not based on the sum for all years, how can I do it? That is to say, I would like to show values for Apple, Pear, and Banana 100, 200, blank for 2010, blank, 500, 350 for 2011, and 600, 100, blank for 2012. It would be greatly appreciated if you could offer some helps. Thanks

@SQLBI Год назад

See www.sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/