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.
Hello, I'm newby in DAX. i need to ask for favour some experts because I dot't get how to sum it.
Thanks in advanced.
I try to sum value from product by weeks
My measure sum all not filtered by
Qty total for Product (code) = CALCULATE(SUM('Sheet'[Qty]);ALLSELECTED('Sheet'[My_date_column]);'Sheet'[Column_with_nr_week])
Dear Derek you have right about my knowledge of Dax. I need to start learn:)
Meanwhile I solve my case in those formula
Measure = CALCULATE ( SUM ( 'Sheet'[Qty] ); ALLEXCEPT ( 'Sheet'; 'Sheet'[NR_of_week]; 'Sheet'[Material (code)] ) )
Mate, there is a good rule in DAX:
DO NOT USE A FUNCTION IN YOUR CODE IF YOU DON'T KNOW PRECISELY HOW IT WORKS.
Let this statement above sink in. If you don't stick to it, you'll be sorry rather sooner than later. Please, before you start using something in your DAX code read about it. Here's a good source: www.daxguide.com.
Do you have any idea how ALLSELECTED works? No? That's what I thought.
ALLSELECTED is a very complex DAX function that works with something that's called "shadow filter context." To use it correctly you have to know quite a few things. Once again, please read about it.
Your measure should in all likelihood be this:
Qty total for Product (code) = SUM( 'Sheet'[Qty] )
I'd also urge you to read about the proper dimensional design.
Best
Darek
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |