Ranking Dinámico en Power BI. Rankx + Isfiltered + Coalesce.

RANKX is a powerful DAX function in Power BI that allows you to sort and rank items within a table or expression. Rankx can dynamically adapt to different hierarchy levels. The ISFILTERED function in DAX checks if a filter is active on a specific column. It returns TRUE if the specified column has a filter, and FALSE if it does not. In the context of the dynamic ranking we're discussing in this video, ISFILTERED plays a crucial role in determining which level of the hierarchy we're exploring in the array. The COALESCE function in DAX returns the first non-null value from its arguments. This is useful when you have a series of values ​​and want to use the first one that is not BLANK() or null.