Finally today i have understood what is the use of ALL in calculate.. Thanks for your video ❤

Of all the descriptions and help I've perused, this is the one that finally made sense. I GOT IT the first time you ran through. Gusen tack!

Very Useful and love the way you explained and break in small videos each functions.

Love your tutorials. DAX still does my head in. :)

One of the best way of teaching! Thank you very much!

Thank you for the help! This was helpful.

Started to Learn Dax today - survived from DAX friday 1 to this now ..very well explained . Trying to catch up all the 121 video .Amazing easy to understand.

I really love your explanations on such complex subjects for Power BI

Quite a good explanation. Thanks for these videos

this is a great introduction video

I got what I was looking for, nice explanation.

Thanks for your video, it is very useful to follow with your material provided and do it at my desktop, thats very considerate of you :)

I've searched far and wide, listen to many a ramblings before I stumbled upon your channel. Massive thank you for the delivery, content and presentation.

Gracias!!! Me esta facilitando el avance de mis conocimientos en DAX.

Nice video, CALCULATE () is very useful, but so complex. I check two videos, Part 1, Part 2, for refresh my knowledge about CALCULATE()

Thanks Curbal for this great video. I hated the CALCULATE function because I was always trying to use it as a calculated column instead of a measure. MY MISTAKE. When you made that clarification in the video I thought, "OK, now I know the problem." I think I will now 'love' the CALCULATE function. Again, big thanks (and yes if you couldn't tell, I'm new to DAX). By the way, DAX, where have you been all my life?! Big fan, thx.

The session on DAX- Calculate has been thought provoking :):). Often in business performance analysis, we are required to consider relative performance of products (or such other dimensional parameter) across single/multiple metrics (sales/revenue/pipeline size). The behaviour of DAX- calculate function that allows overwriting filter context presents a rather unique and easy way to create the aforesaid KPI/Metric as a measure on the go. E.G.in the example you have demonstrated, the 'cal w filter' measure can be used as the denominator against the 'CAL tot sales' as numerator to arrive at the aforesaid metric. The alternate solution would require us to create a calculated column (using if) which is clearly sub-optimal computationally. Thanks a bunch for the insight. I will be sure to go thru' the videos in this series in detail to pick up such insights. Do please keep up the good work. cheers

Thanks for the video

Hello, Very nice video, had one question though, is it possible to ignore slicers current filtering and use filter during calculate to apply filter to retrieve any value to add in current calculation? Please help me with this.

Thank you, Ruth, for this presentation.

Very well explained.

Ruth, Always, THANK YOU. In this case though, thanks for the Henry Ford "as long as its black" reference. You might not realize it, but, now, I'll always recognize this problem in my own reports with, "Oh... Hey Henry!" Actually... you might realize that.

How simply explained...superb

Thank you!

Hola Ruth gracias por este gran esfuerzo y material de excelente calidad he aprendido mucho con tus videos. ¿Pero cómo se consiguen los archivos para seguirte en el video? no logro ubicarlos. Gracias! Saludos.

Thanks for this video, Ruth...Can we do one thing, Can we get Total Sales for all the product in one column except Queso Cabrels or BLANK for Queso Cabrels?

Hi Ruth, How filter works in calculate. if we have multiple filters,does filtering start from the last filter or the first filter?Or all filters applied simultaneously?Does order of filter add to performance?

Hi Ruth! Thanks for your videos! Do you have any video about Filter and All functions?

Hello, what if I want to use the measure that I have created using the calculate and the filter later on in order to create another measure but somehow ignoring the filter again. For example 1 a = 10 2 a = 20 3 a = 30 4 c = null 5 b = 1 6 b=2 7 b = 3 8 c = -10 So i want to calculate the value of b from a how can I do this? I have managed to sum the values for a and the values of b, but when I do a/b it keeps the filter, I want to get the value of b and the ignore the filter later on so I can use it as a sum in my calculations later on without the filter

It took me a few minutes to figure out how to wire up the FilteredProducts table you have. Creating the table wasn't too hard, but then I had to tweak the relationships so everything was joined to the filtered table.

I'm not getting the excel file , the link in the description is not valid maybe it's not responding.. Please make it available , your teachings are so understandable and helpful but If i could get the data it'd be more helpful to me , Thankyou !

Hi Ruth. I have a question. If you re using ALL to remove all filters why is it when you drop the year column in, it’s responding to the year filter?

Question: In this ex. when Calculate with filter or Calculate All, why did it not populate any values for the blank product name (1st row). But when %ofSales was done, it showed the correct %. Just curious... Thanks in advance

excellent!!!

thanks for the video. I have a question. So, my measure calculates number of people correctly, but does not show the number of cars (corresponding to these people ) correctly. I mean in slicer. I used calculate (distinctcount(_,_)) could you please help me? thanks

Hi, how can we calculate three or more according to criteria? Please I need a answer

He empezado a ver los videos. Muy interesantes. Tengo algo, que me deja un poco intrigado. He ido actualizando PowerBI y quizas sea algo que cambió en la última actualización (no tengo como comprobarlo pues nunca abrí este archivo con la versión anterior), o es algo que está mal configurado (pero no puedo imaginar que podría ser). He bajado los archivos ya resueltos, tal como los has colgado, y lo que veo en la matriz es diferente a lo que se ve en el video. En Cal w filter ya no aparecen los totales repetidos en los productos que no son QuesoCabrales (se ven en blanco). En All si aparecen en todos los productos. En el video de la segunda parte ocurre algo parecido, ya se han filtrado (no se visualizan) los totales que estan en productos no relacionados con los filtros. Ha cambiado la funcion DAX, ha cambiado el visual o hay algo mal configurado?

how filtered product table is created i cant see it in northwind database

Hi Ruth, Again I have some query for knowledge purposes "Tot sales" look good but you minus 1 from a discount I can understand if the discount is 0 then all result will be 0. If there has some discount 2 or 3 then we are subtracting 1 from it and give an incorrect result. moreover, If the discount is 1 then it will become 0. Please correct me if I am wrong.

Hi, Love your videos, thanks a million. I cannot find the file that goes with the video ? Is it still available ?

Confused... So CALCULATE is a way to sum a measure, while overwriting the filter and introducing its own filter?

good explanation, please can you tell me how to make the white area bigger in power bi desktop because i notice in the video that your area where you put tables is bigger than mine

In the previous video the total sales was 1.2M, how did this change ?

Hi Ruth/ I am waiting for a video for new feature called incremental refresh. where we can have dynamic parameter .Example Start date > max(SalesDate from existing Table) and end Date will be some future date. Regards Sabir

Thank you. Ruth. I am a new user and learn PBI from your video a lot. In this presentation, I get two things which is different from your presentation. (1) Calculate with filter only return with total of one product. For the rest of products, it returns with blank. Did I do something wrong? (2) Calculate with all products, the results is the same with sum of total. Can you tell me more about it? Thanks in advance.

Please if no possible download the file the day friday the link is broken, how made for download the files, is very important for study the function dax. THANKS A LOT, i wirte from cali colombia

Thank you Ruth. As you Cal with Filter "Queso Carbales" How to add another Product? Suppose i want to show two products " Chai and Chang" How to filter both?

Hi Ruth, At 13:33 of video how is the % 81 & 82 when the denominator is blank. Please explain.

Hi Ruth Are you using Dark Theme of Power Bi? It would be great if you guide me the process. Thanks in advance!

Hi Ruth, Thanks for the great video. I still don't understand why we create the calculated column Tot_Sales. You are saying on the video that this is to make sure the measure doesn't get invalid when the name of the calculated column changes, but I still don't get it. Can you clarify more please?

Exclente! consulta como caluclar la tasa crecimiento % de las ventas de mes a mes de un año calendario, gracias

how to download only dataset?

CAN YOU PLEASE TELL ME HOW CAN I USE IF STATEMENT WITH STRING OR IF THERE IS ANOTHER WAY OR FUNCTION THAT CAN REPLACE IF STATEMENT TO USE WITH STRING?

hhi.. #Ruth ...Have you made or could you some video on " how to extract data or hw to connect microsoft visual studio"

I have a question, how to calculate COUNTIFS of Excel in Power BI, for example, COUNTIFS=(d:d, d2, m:m, m2)

Why product name is empty but total sales is 864182 for the first item?

how to get the excels which you have used in PowerBI??

Thanks, I have a question: what should I do if I want to ignore filters from products and years simultaneously?

How can I subtract values under the same column using calculate?

files could not download.

Calculate just ignores the external filter. So you need the filter formula.

Hi Ruth, I am unable to download the power bi file. Can you please update the correct link in your website.

how dim table is created...

Hi. Love your videos. I wonder why it gives different outcome if I filter by Queso Cabrales in "Product" table. Is it because it has direct relationship with "Order details" table? Here is the screenshot: prntscr.com/igd2rz

Best Videos on DAX , Thanks Ruth i have kept message to you on LinkedIn can you please check

How do I calculate values from a different date? I want to calculate the difference of an earlier measure vs today()'s measure. How the fuck do I do that???