Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Im in the learning path of DAX...i have read about ALL() and below is my observation
* Acts like a filter modifier
*Gives distinct value when used with column name
*Gives combination of values when used with table name
*It ignore the external filter like visual/Slicer and impose the internal filter
However when i was doing practicals im confused how the ALL function is behaving
Numeratr = sum('Order Details'[Sales])
Denominatr = calculate(sum('Order Details'[Sales]),all('Orders'))
Numoverden = divide([Numeratr],[Denominatr],0)
My question is why is it ignoring filters on Lastname column when it is no where mentioned in a measure?
Below is the relationship model
Regards,
HB
@Anonymous , all on order should remove all filters on order. So Filter from other table will also go away.
https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
@amitchandak only the Order table filter get removed .However why is it not slicing the data as per Last name which is coming from Employe table?
@Anonymous , All means on the join ID too. Create a separate table for the Order ID and join with this table. and use all on that table and check.
@amitchandak so you mean to say that since order table has employee id as foreign key even that table gets effected with ALL() function ??
@amitchandak can you help me here please, does this mean if a table has foreign key even those tables are affected??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
86 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |