Deep dive into measure filters in Power BI Desktop

Показать описание

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.

SQLBI

Рекомендации по теме

Комментарии

Enjoying DAX because of you! Thanks Alberto😀

sane

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

khurramshahzed

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?

IoriYagamiKOF

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

Amr-Ibrahim-AI

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

frsket

Could the alternative solution be to change the ALLSELECTED() function in the Ranking measure 4:37 to ALL()?

gizmo

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

johnjiang

Thank you for democratizing such advanced knowledge. God Bless!

ejazahmedev

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

matthewdufty

This is such an excellent explanation!! Thank you

sriramsundar

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

Bharath_PBI

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

odeddror

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. :-(

christianstork

You guys are wearing out my Like button.

brianligat

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

LuciusSullaFelix

Deep dive into measure filters in Power BI Desktop

Deep dive into measure filters in Power BI Desktop

ADC Filtering Deep Dive

Microsoft Power BI: Deep dive into DAX evaluation context - BRK3060

Section 16 - 🔍💡 DAX Deep Dive: Master Cascading Filters for Interactive Power BI Reports! 📊🚀...

DAX for Power BI - Understanding Filter Context

Power BI - Filter by a Measure in a Slicer

CALCULATE Deep Dive

ROW CONTEXT & ITERATORS | DAX Essentials 2 #shorts

Date Harvest Deep Dive - Power BI Time Intelligence

Power BI Community Solution Deep Dive: N to 1 to N Measures

DAX Fridays! #78: When should I use FILTER() with CALCULATE?

Understanding CALCULATE in DAX: Filters

Measure Filtering in Power BI

A TWIST on dynamically filtering visuals by a slicer in Power BI

CONTEXT TRANSITION | DAX Essentials 3 #shorts

Mastering your DAX skills: deep dive into evaluation context - Power BI Bootcamp 2022

DEEPEST POOL IN THE WORLD!

Kepler Deep Dive- Measure pod energy consumption(CNCFMinutes 26)

Slicing by Measure Categories in Power BI

Multi Measure Dynamic Visuals - Data Viz Technique In Power BI

Power BI Dev Camp Session 18 - Developer Deep Dive into Row Level Security (RLS)

How to use Measure as a Filter in Power BI | Measure in a Slicer | Power BI Tips and Tricks (45/100)

#Webinar: Image Analysis – Deep dive into the world of pixels

DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship