ALLSELECTED - DAX Guide

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

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

50% 1

ALLSELECTED: Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside the query, but keeping filters that come from outside.
dax.guide/allselected/
This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.

How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...
Code, run, and share DAX with DAX.do: dax.do/?aff=yt

#dax #powerbi #ssas #tabular #analysisservices #powerpivot

Наука

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

4 май 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@ViswanathReddy1902 3 дня назад

Wow. Just Wow. I can't describe the happiness i felt after watching this in words.

@IbrahimNajjar-by2dk Год назад

I am following a module on Dax, I keep being disappointed with the quality of examples they give and struggle to understand what the point is, then I come here to RU-vid to see what Alberto has to say about it and then feel better about myself making sure that it was actually the example that was terrible not my understanding. Thanks Alberto, you are a star.

@soy_leche Год назад

Fantastic explanation. Simple and to the point.

@jdiazrop 4 месяца назад

I feel that with Alberto's explanitions I could understand whatever. Quantum physics? , space shuttle engineering ?, no problem with Alberto. Sure. Thank you.

@MrXmaciek Год назад

Thanks, the best DAX content in internet

@GeekSP1 Год назад

I came for something, and found answer for something else. 😅😅😅 Thank you Alberto

@ashishmohan4707 3 года назад

Hi Alberto you are amazing .....You are real champion on DAX. What a way to deliver the DAX,,,its amazing . very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

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

this gent is my DAX hero

@pilarbaldominos2505 3 года назад

Great explanation!

@DarkOri3nt 3 года назад

We had hit this road block and had to get Chris Webb in to help us with it. We had a model that had an item table with a 1 to 1 to an attribute table users were filtering on this by columns in the item table. To get the sum percentage we had to use a measure sum(col) / sum(col), allselected(item group,fullgroup) even then it wasn't great as the users wanted the total to change by whatever they were slicing on in the report. Almost need some form of dynamic measure slicing for this percentage mix usecase.

@tsgla Год назад

wow! amazing knowledge

@milig.8106 2 года назад

Thanks for the Video! Can we grab values from another table unrelated, using selected values and All selected ?

@BhargavChebolu 4 месяца назад

what can I use instead of allselected() inside the calculate function when the calculate is inside of sumx?

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

thank you

@RetaxChennai 3 года назад

Please do a video on the difference between ALLSELECTED and KEEPFILTERS. Both are very similar.

@alvarorodriguezlasso 3 года назад

¡Ciao! Regards from Cali Colombia...Espectacular explanation. This function is something hard to understand

@RCWithPopeye 3 года назад

awesome

@yeeren8970 3 года назад

Hi Alberto, if I use it like this "MAXX(ALLSELECTED('Date'[Date]), [Total Sales])" for caculate the maximum sales, is that bad? do i have to rewrite it as a calculate modifer?

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

It depends on what you want to get as a result. Your formula applies ALLSELECTED only to the Date column of the Date table, ignoring ALLSELECTED for other columns/tables. It is more likely you want to use ALLSELECTED ( Date ), but it depends on what you want to get as a result.

@shiny_shoes5878 Год назад

would there be a way to only keep the filter context of the visual the measure is being used in, using your example keep the filter context created by the Brand table but exclude the filter context from the slicer & page filters? i.e. the opposite of ALLSELECTED

@SQLBI Год назад

No, it is not possible.

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

In a Matrix visual, when ALLSELECTED removes the row context, it leaves any NONVISUAL filters that are current in the stack. It doesn't drop back to the "normal" arguments in the SUMMARIZECOLUMNS for the Matrix. My understanding is that NONVISUAL "does not impact Measures, only the rows of the Matrix". This is pretty horrible, is it a bug?