One question Let's say measure is Measure1 = CALCULATE( [Total Sales] , ALL(products), Product[Category] = "Audio") Now in the matrix visual, we have Category, Subcategory, Product Name and above measure in the values field. So the measure will give sales of only audio category. Now the confusion is, if we have used ALL(product), we are saying to ignore filter on product table then how come the third argument i.e. porduct [category] = "Audio" is able to work in spite of ALL?? Because my assumption is this third argument should not work because ALL must restrict filtering products table. But Its actually filtering. How is calculate behaving? Kindly help me. Thanks in advance😊😊🎉
Thank you Pavan Sir!!!!!!
Do you have an ongoing power BI classes where we can learn systematically on everyday basis? would like to join :)
Modiji : Moye Moye 😅
One question
Let's say measure is
Measure1 = CALCULATE( [Total Sales] , ALL(products), Product[Category] = "Audio")
Now in the matrix visual, we have Category, Subcategory, Product Name and above measure in the values field.
So the measure will give sales of only audio category.
Now the confusion is, if we have used ALL(product), we are saying to ignore filter on product table then how come the third argument i.e. porduct [category] = "Audio" is able to work in spite of ALL??
Because my assumption is this third argument should not work because ALL must restrict filtering products table. But Its actually filtering. How is calculate behaving?
Kindly help me. Thanks in advance😊😊🎉